Top 10 Features of SQL Developer everybody should use, even in the Cloud Heli Helskyaho DOAG 2016
Introduction, Heli Graduated from University of Helsinki (Master of Science, computer science), currently a doctoral student, researcher and lecturer (Big Data, Unified Databases) at University of Helsinki Worked with Oracle products since 1993, worked for IT since 1990 Data and Database! CEO for Miracle Finland Oy Oracle ACE Director Ambassador/EOUC (EMEA Oracle Users Group Community) Public speaker and an author Winner of Devvy for Database Design Category, 2015 Author of the book Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press, 2015), co-author for Real World SQL and PL/SQL: Advice from the Experts (Oracle Press, 2016) Copyright © Miracle Finland Oy
Helskyaho Heli, Valin-Raki Elise
Copyright © Miracle Finland Oy
Oracle SQL Developer vs Oracle SQL Developer Data Modeler Two separate products BUT There is a version of Data Modeler that is integrated in SQL Developer
To see the datastructures and objects in the database and to maintain the data: SQL Developer To design the database and to maintain the data structures: Data Modeler To design the data architecture: Data Modeler Copyright © Miracle Finland Oy
In this session 1. Useful shortcuts 2. Queries 3. Debugger 4. Compile 5. Export the result set 6. Data Modeling 7. Documentation and Reports 8. Database Copy and Diff 9. Schema Browser 10. Explain Plan Misc Copyright © Miracle Finland Oy
1. Useful shortcuts
Copyright © Miracle Finland Oy
Run Statement: Ctrl+Enter or F9
Copyright © Miracle Finland Oy
Shift+F4
Copyright © Miracle Finland Oy
Add your own shortcuts
Copyright © Miracle Finland Oy
Code Templates
Copyright © Miracle Finland Oy
2. Queries
Copyright © Miracle Finland Oy
Preferences, Line Numbers
Copyright © Miracle Finland Oy
The Query Result
Copyright © Miracle Finland Oy
Copy: Ctrl+Shift+C
Copyright © Miracle Finland Oy
Paste (Ctrl+Shift+C) with Ctrl+V
HIREDATE 14.10.2010 14.10.2013 01.02.2013 02.02.2013
Copyright © Miracle Finland Oy
What was the SQL for the result set?
Copyright © Miracle Finland Oy
SQL History
Copyright © Miracle Finland Oy
SQL History
Copyright © Miracle Finland Oy
3. Debugger
Copyright © Miracle Finland Oy
Preferences
Copyright © Miracle Finland Oy
Compile for Debug
Copyright © Miracle Finland Oy
Toggle Breakpoint
Copyright © Miracle Finland Oy
Debug
Copyright © Miracle Finland Oy
Worth reading http://www.thatjeffsmith.com/archive/2014/02/howto-start-the-plsql-debugger/ https://galobalda.wordpress.com/2014/02/17/sqldevelopers-plsql-debugger-and-oracle-12c/
Copyright © Miracle Finland Oy
4. Compile
Copyright © Miracle Finland Oy
Compile Invalid, Compile All
Copyright © Miracle Finland Oy
5. Export the result set
Copyright © Miracle Finland Oy
Export the result set
Copyright © Miracle Finland Oy
Export the result set
Copyright © Miracle Finland Oy
Preferences
Copyright © Miracle Finland Oy
6. Data Modeling
Copyright © Miracle Finland Oy
Redaction
Copyright © Miracle Finland Oy
Quick DDL
Copyright © Miracle Finland Oy
Indexes
Copyright © Miracle Finland Oy
Table (Model)
Copyright © Miracle Finland Oy
Data Modeler Reports from Reporting Repository
Copyright © Miracle Finland Oy
Data Modeler
Copyright © Miracle Finland Oy
Data Modeler
Copyright © Miracle Finland Oy
7. Documentation and Reports
Copyright © Miracle Finland Oy
Documentation
Copyright © Miracle Finland Oy
Documentation
Copyright © Miracle Finland Oy
Documentation
Copyright © Miracle Finland Oy
Data Dictionary
Copyright © Miracle Finland Oy
Data Dictionary
Copyright © Miracle Finland Oy
Database Administration
Copyright © Miracle Finland Oy
Database Administration
Copyright © Miracle Finland Oy
Database Administration, TOP SQL
Copyright © Miracle Finland Oy
DBA
Copyright © Miracle Finland Oy
Instance Viewer
Copyright © Miracle Finland Oy
8. Database Copy and Diff
Copyright © Miracle Finland Oy
Database Copy
Copyright © Miracle Finland Oy
Database Copy
Copyright © Miracle Finland Oy
Database Diff
Copyright © Miracle Finland Oy
Database Diff
Copyright © Miracle Finland Oy
Database Diff
Copyright © Miracle Finland Oy
Database Diff
Copyright © Miracle Finland Oy
Database Diff
Copyright © Miracle Finland Oy
Preferences
Copyright © Miracle Finland Oy
9. Schema Browser
Copyright © Miracle Finland Oy
Schema Browser
Copyright © Miracle Finland Oy
Find DB Object
Copyright © Miracle Finland Oy
Find DB Object
Copyright © Miracle Finland Oy
10. Explain Plan (F10)
Copyright © Miracle Finland Oy
Explain Plan (F10)
Copyright © Miracle Finland Oy
Autotrace (F6)
Copyright © Miracle Finland Oy
Autotrace (F6)
Copyright © Miracle Finland Oy
Preferences
Copyright © Miracle Finland Oy
Misc
Copyright © Miracle Finland Oy
Licensing?
Copyright © Miracle Finland Oy
Preferences
Copyright © Miracle Finland Oy
Copyright © Miracle Finland Oy
THANK YOU!
QUESTIONS?
[email protected] Twitter: @HeliFromFinland Blog: Helifromfinland.wordpress.com
Copyright © Miracle Finland Oy