1 / 27

SQL Developer Tips and Tricks

SQL Developer Tips and Tricks. Rick Greenwald Director, Product Management, Database Cloud Service. Program Agenda. A brief history of SQL Developer Top 10 tips and tricks.

isleen
Download Presentation

SQL Developer Tips and Tricks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Developer Tips and Tricks Rick GreenwaldDirector, Product Management, Database Cloud Service

  2. Program Agenda • A brief history of SQL Developer • Top 10 tips and tricks

  3. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  4. Graphic Section Divider

  5. A brief history of SQL Developer

  6. Oracle SQL Developer Overview Database IDE 2,500,000+ users worldwide Windows, OS X, *NIX Administer APEX Listener Deploy to Oracle Cloud

  7. 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 Summer 2013

  8. Support for Other Oracle Database Products Times Ten Data Miner XML DB Spatial & Graph

  9. SQL Developer Data Modeling Strategy and Analysis Import Models Data Type Domains DFD ERD Multidimensional Logical Reporting Database Design Physical Star Schema Relational

  10. Top 10 tips and tricks

  11. 1. Configure Your Preferences Make things look nice Disable unused extensions Automatic can be ‘bad’ I like ‘more’ grids

  12. 2. Recall Previous SQL via the Keyboard Fires off of View > SQL History (F8)

  13. 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

  14. 4. Drag & Drop Multiple Tables to Worksheet

  15. 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

  16. 5. Viewing PL/SQL Output (Include Ref Cursors)

  17. 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

  18. 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

  19. 7. Extend SQL Developer With Extensions Write your own (XML + SQL) Check for Updates Pay $-$$ Free ones too!

  20. 8. Excel Stuff Export data to Excel Import from Excel to table Existing Build New One CSV Exports are Faster

  21. 9. See What SQL #SQLDev is Generating Switch nondebug to debug in sqldeveloper.conf

  22. 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

  23. SQL Developer Resources OTN – SQL Developer • Forums • By Example Tutorials • Jeff Smith’sTips & Tricks Blog Download the Developer Days VirtualBox Image! 11gR2, SQLDEV, APEX, APEX Listener, Times10, OEM and more!

  24. Additional 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 :)

More Related