Top 10 Features of SQL Developer everybody should use

Top 10 Features of SQL Developer ... co-author for Real World SQL and PL/SQL: Advice from the Experts (Oracle Press, 2016) Introduction ... to-start-t...

11 downloads 529 Views 4MB Size
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