slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle SQL Developer Tips & Tricks PowerPoint Presentation
Download Presentation
Oracle SQL Developer Tips & Tricks

Loading in 2 Seconds...

play fullscreen
1 / 24

Oracle SQL Developer Tips & Tricks - PowerPoint PPT Presentation


  • 221 Views
  • Updated on

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. de facto Oracle IDE/GUI 3,500,000 + users worldwide

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

Oracle SQL Developer Tips & 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
    Presentation Transcript

    1. Oracle SQL DeveloperTips & Tricks Jeff SmithSenior Principal Product Manager

    2. Agenda A Brief History of the Product Talk the Tip Show the Tip Slides + Live Demo Questions at the End

    3. Oracle SQL Developer Overview de facto Oracle IDE/GUI 3,500,000+ users worldwide Windows, OS X, *NIX Installed with Oracle Database MOS via DB license

    4. 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 (2013)

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

    6. SQL Developer Data ModelingIncluded for free, also available as a separate download/program Strategy and Analysis Import Models Data Type Domains DFD ERD Multidimensional Logical Reporting Database Design Physical Star Schema Relational

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

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

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

    10. 4. Drag & Drop Multiple Tables to Worksheet

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

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

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

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

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

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

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

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

    19. 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!

    20. 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 :)

    21. Open World Sessions *Marriott Marquis