320 likes | 573 Views
Oracle SQL Developer Tips & Tricks. Jeff Smith Senior Principal Product Manager. Agenda. A Brief History of the Product Talk the Tip Show the Tip Slides + Live Demo Questions at the End. Oracle SQL Developer Overview. Database IDE 2,500,000 + users worldwide
E N D
Oracle SQL DeveloperTips & Tricks Jeff SmithSenior Principal Product Manager
Agenda A Brief History of the Product Talk the Tip Show the Tip Slides + Live Demo Questions at the End
Oracle SQL Developer Overview • Database IDE • 2,500,000+ users worldwide • Windows, OS X, *NIX • Administer APEX Listener • Deploy to Oracle Cloud
SQL Developer Release History • Project Raptor (2005) ~ Oracle SQL Developer v1.0 (2006) • Version 1.5 (2008) • Version 2.1 (2009) • Version 3.0 (2011) • Version 3.1, 3.2 (2012) • Version 4.0 EA (now!)
Support for Other Oracle Database Products • Times Ten • Data Miner • XML DB • Spatial & Graph
SQL Developer Data Modeling Strategy and Analysis Import Models Data Type Domains DFD ERD Multidimensional Logical Reporting Database Design Physical Star Schema Relational
1. Configure Your Preferences • Make things look nice • Disable unused extensions • Automatic can be ‘bad’ • I like ‘more’ grids
2. Recall Previous SQL via the Keyboard Fires off of View > SQL History (F8)
3. Format Query Results Directly to CSV, XML, ... • Add Comment • Execute via F5 (Script) • Comment labels match grid export formatter labels • ONLY works in SQLDev
4. Drag & Drop Multiple Tables to a Model • Shift, Select, Drag, Drop • OR Ctrl+Select, Drag.. • Ctrl walks the dependency tree • Preview DDL, save, export, etc
5. Don’t Like the Tree? Open a Schema Browser • Right-Click on a Connection • Drop Down Controls for • Schema • Object • Same Functionality as Tree
6. Ctrl+Click, Shift+F4, Object Search to Quick Open an Object • Hold down Ctrl... • Mouse over object text... • CLICK to open object editorOR SHIFT+F4OR View > Find DB Object
7. Extend SQL Developer With Extensions • Write your own (XML + SQL) • Check for Updates • Pay $-$$ • Free ones too!
8. Excel Stuff • Export data to Excel • Import from Excel to table • Existing • Build New One • CSV Exports are Faster
9. See What SQL #SQLDev is Generating Switch nondebug to debug in sqldeveloper.conf
10. Split Editors | New Editor Tab Groups Right Click in the Editor Tab, split gives you 2 independent views of the editor, New Tab Group lets you see multiple editors at once
SQL Developer Resources OTN – SQL Developer • Forums • By Example Tutorials • My Tips & Tricks Blog Download the Developer Days VirtualBox Image! 11gR2, SQLDEV, APEX, APEX Listener, Times10, OEM and more!
Cliff’s Jeff’s Notes • Customize Preferences • Recall SQL History via keyboard • Script Output in CSV, HTML, ... • Drag ‘n’ Drop Tables to Worksheet • Drag ‘n’ Drop Tables to Model • PL/SQL Output • Schema Browser • Ctrl+Click, Shift+F4, Object Search • Extensions • All of my #SQLDev Posts :)
Open World Sessions *Marriott Marquis