Tips and tricks for SQL Developer and SQL Developer command line
summary
Demo-heavy session lists concrete shortcuts and new features: keyboard and mouse object open plus Preferences tweaks for SQL Developer, terminal-focused automation with SQLcl datapump export and OCI upload, tiny JavaScript scripts that write BLOBs to files (JavaScript blob export), browser-based tooling and live charts in Database Actions dashboards, and the diagnostics-focused info+ command that shows per-column distinct counts and histograms. Tools are free, cross-platform, and aimed at cutting repetitive typing.
AI-written summary · about
chapters (17)
- 0:00Intro
- 0:30Modern Tooling Empowers Users, Increases Productivity
- 1:45Today's Goal: 3 Power Tips for Each Product Quick, fun, transformative
- 2:50SQL Developer FREE
- 4:11Click into Objects
- 5:22TIP 82: Don't use the default options
- 6:22TIP 83: Double your Feature Set - Open the DBA Panel
- 10:15Formatting
- 11:27Data Guard & Data Pump, Coming Soon!
- 13:17JavaScript
- 15:52Meet the New Boss, Same as the Old Boss
- 17:13TIP 12: Command Palette - Everywhere you code
- 20:34TIP 3: Charting Dashboards are the new Awesome
- 23:15Know SQL, PL/SQL? You can build REST APIs!
- 25:47Already wrote your PL/SQL? Just Enable it!
- 27:26SQL Developer Data Modeler
- 30:16TIPS: Generate DDL
related talks
33mTips and tricks for the Oracle Database developer
20mDatabase developer productivity tips and tricks
34mQuery any database in Oracle Cloud using your favorite web browser
48mDevOps Discovery: Navigating the Database Landscape
20mIntro to Azure Data Studio
50mA Practical Starter Guide to SQL Notebooks
51mAzure Data Studio and the Surprises Inside
52mLinux terminal for java developers — boost your efficiency!