Create ER Diagram using Oracle Sql Developer

To create a diagram for existing database schema or its subset:

File → Data Modeler → Import → Data Dictionary → select DB connection (add if none) → Next → last few steps intuitive.

(SQL Developer version 3.2.09.23.)

SQL Developer Shotcuts

1. ctrl-enter : executes the current statement(s)
2. F5 : executes the current code as a script (think SQL*Plus)
3. ctrl-space : invokes code insight on demand
4. ctrl-Up/Dn : replaces worksheet with previous/next SQL from SQL History
5. ctrl-shift+Up/Dn : same as above but appends instead of replaces
6. shift+F4 : opens a Describe window for current object at cursor
7. ctrl+F7 : format SQL
8. ctrl+/ : toggles line commenting
9. ctrl+e : incremental search

--

Configuring Keyboard Shortcuts in SQL Developer

Tools > Preferences > Shortcut Keys