Oracle SQL Developer Top 10 Tips & Tricks

  • Published on
    15-Jul-2015

  • View
    19.279

  • Download
    8

Transcript

Oracle SQL Developer Top 10+ Tips & TricksCopyright 2014 Oracle and/or its affiliates. All rights reserved. |1Oracle SQL DeveloperTips & TricksJeff SmithJeff.d.smith@oracle.com || @thatjeffsmithSenior Principal Product ManagerDatabase Development Tools GroupOracle Confidential Internal/Restricted/Highly RestrictedCopyright 2014 Oracle and/or its affiliates. All rights reserved. |Copyright 2014 Oracle and/or its affiliates. All rights reserved. |This is a Title Slide with Picture and Logo slide ideal for including a picture and partner or product logo with a brief title, subtitle and presenter information.To customize this slide with your own picture:Right-click the slide area and choose Format Background from the pop-up menu. From the Fill menu, click Picture and texture fill. Under Insert from: click File. Locate your new picture and click Insert.To Replace the LOGO on this sample slide:Right-click the sample LOGO and choose Change Picture. Navigate to the location where the new logo is stored, select desired logo file and click on the Open button to replace the sample logo.2Improve application developers experience A Little History Talk the Tip Show the Tip Questions As We Go! Take notes or borrow mine at the endAgendaCopyright 2014 Oracle and/or its affiliates. All rights reserved. |Oracle SQL Developer FREE Oracle Database IDE/GUI Windows, OS X, *NIX More than 3,500,000 users worldwide My Oracle Support available via your DB licenseCopyright 2014 Oracle and/or its affiliates. All rights reserved. |SQL Developer Data ModelerIncluded for free, also available as a separate download/programStrategy and AnalysisRelationalDatabase DesignData TypeStar SchemaPhysicalMultidimensionalERDDFDLogicalReportingImport ModelsDomainsCopyright 2014 Oracle and/or its affiliates. All rights reserved. | 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)Release HistoryCopyright 2014 Oracle and/or its affiliates. All rights reserved. | Automatic can be annoying Disable: Open Object on Single Click I like my data to stay put Enable: Show query results in new tabs1. Configure the Automatic StuffCopyright 2014 Oracle and/or its affiliates. All rights reserved. | Adjust delay as comfortable Suppress automatic suggestions if too many hits Turn off completely and use ctrl+spacebar Tweaked in v4.0.21B. Show the Automatic Completion StuffCopyright 2014 Oracle and/or its affiliates. All rights reserved. |In lieu of clicking through SQL History (F8)2. SQL HistoryCopyright 2014 Oracle and/or its affiliates. All rights reserved. | Add Comment Execute via F5 (Script) Comment labels match grid export formatter labels ONLY works in SQLDev3a. Format Query Results Directly to CSV, XML, etcCopyright 2014 Oracle and/or its affiliates. All rights reserved. |3b. Copying Grids WITH Column HeadersCopyright 2014 Oracle and/or its affiliates. All rights reserved. |4a. Drag-n-Drop Objects to EditorCopyright 2014 Oracle and/or its affiliates. All rights reserved. | Shift, Select, Drag, Drop OR Ctrl+Select, Drag.. Ctrl walks the dependency tree Preview DDL, save, export, etc4b. Drag-n-Drop Objects to ModelCopyright 2014 Oracle and/or its affiliates. All rights reserved. |5. Viewing PL/SQL Execution Output (RefCursors) Copyright 2014 Oracle and/or its affiliates. All rights reserved. | Right-Click on a Connection Drop Down Controls for Schema Object Same Functionality as Tree6. Schema BrowserCopyright 2014 Oracle and/or its affiliates. All rights reserved. |Hold down Ctrl...Mouse over object...CLICK to open objectSHIFT+F4 (DESC)Find DB ObjectAlt+G on object text7. Three More Ways to Open/Browse ObjectsCopyright 2014 Oracle and/or its affiliates. All rights reserved. | Create your ownobject actions Extend the objecteditorsSee Kris talk for more awesomeness8. Extend the product with XML+SQLCopyright 2014 Oracle and/or its affiliates. All rights reserved. | Export data to Excel Import from Excel to table Existing Build New One XLSX Exports in 4 are faster9. Excel StuffCopyright 2014 Oracle and/or its affiliates. All rights reserved. |Right Click in the Editor Tab, split gives you 2 independent views of the editor, New Tab Group lets you see multiple editors at once10. Split Editors & New Document Tab GroupsCopyright 2014 Oracle and/or its affiliates. All rights reserved. |OTN SQL Developer Forums By Example Tutorials My Tips & Tricks BlogResourcesCopyright 2014 Oracle and/or its affiliates. All rights reserved. |Customize PreferencesRecall SQL History via keyboardScript Output in CSV, HTML, ...Drag n Drop Tables to WorksheetDrag n Drop Tables to ModelPL/SQL OutputSchema BrowserCtrl+Click, Shift+F4, Object SearchCopying Grids w/ Column HeadersXML ExtensionsAll of my #SQLDev Posts :)The Tips in Blog FormatCopyright 2014 Oracle and/or its affiliates. All rights reserved. |Copyright 2014 Oracle and/or its affiliates. All rights reserved. |22

Recommended

View more >