Sql Developer Tips and Tricks - Northeast Ohio Oracle Users Group

Report
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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)
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Support for Other Oracle Database Products
Times Ten
Data Miner
XML DB
Spatial & Graph
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
SQL Developer Data Modeling
Included for free, also available as a separate download/program
Strategy and Analysis
Import Models
Data Type
Domains
DFD
ERD
Logical
Multidimensional
Reporting
Database Design
Relational
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Star Schema
Physical
1. Configure Your Preferences
 Make things look nice
 Disable unused extensions
 Automatic can be ‘bad’
 I like ‘more’ grids
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
2. Recall Previous SQL via the Keyboard
Fires off of View > SQL History (F8)
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
4. Drag & Drop Multiple Tables to Worksheet
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
5. Viewing PL/SQL Output (Include Ref Cursors)
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
6. Ctrl+Click, Shift+F4, Object Search to Quick
Open an Object
 Hold down Ctrl...
 Mouse over object text...
 CLICK to open object editor
OR SHIFT+F4
OR View > Find DB Object
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
7. Extend SQL Developer With Extensions
 Write your own (XML + SQL)
 Check for Updates
 Pay $-$$
 Free ones too!
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
8. Excel Stuff
 Export data to Excel
 Import from Excel to table
 Existing
Build New One
 CSV Exports are Faster

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
9. See What SQL #SQLDev is Generating
Switch nondebug to debug in sqldeveloper.conf
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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!
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Cliff’s Jeff’s Notes
Customize Preferences
PL/SQL Output
Recall SQL History via keyboard
Schema Browser
Script Output in CSV, HTML, ...
Ctrl+Click, Shift+F4, Object Search
Drag ‘n’ Drop Tables to Worksheet
Extensions
Drag ‘n’ Drop Tables to Model
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
All of my #SQLDev Posts :)
Open World Sessions
*Marriott Marquis
ID
Session
Time
Location
8891
SQL Developer and Oracle Database 12c
Tues 12pm
*Golden Gate B
8890
Creating RESTful APIs with Application Express Listener
Wed 10:15am
*Golden Gate C2
8893
Implementing Data Redaction with Data Modeler
Wed 11:45pm
*Golden Gate C2
8894
Faster Oracle Database Migrations with 12c
Wed 5pm
*Golden Gate C2
8928
Collaborative Development and Building with SQL Developer
Thurs 2pm
*Golden Gate C2
10029
Performance Tuning with SQL Developer
Tues 3:45pm
*Salon 3/4
10012
What’s New in SQL Developer 4.0
Tues 5:15pm
*Salon 3/4
10030
Data Modelig 101: Oracle SQL Developer Data Modeler
Wed 1:15pm
*Salon 3/4
10031
Developing REST for On-Premises or the Cloud
Wed 5pm
*Salon 3/4
10047
Oracle Database 12c Features with SQL Developer
Thurs 3:30pm
*Salon 3/4
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

similar documents