Database developer productivity tips and tricks

on YouTube ↗20m

" summary

Live demo of SQL Developer Web and ORDS shows concrete, usable features: browser file loading of SQL/JSON/Avro/XML, a PL/SQL editor with clickable compiler errors, Code Palette (Ctrl‑Shift‑P) and quick-search with numbered results (Ctrl‑1). Data import maps JSON to relational columns or creates tables, BLOBs render media (animated GIF shown), REST APIs are auto-enabled from objects with OpenAPI docs and ref cursor → JSON transformation. Hosted option is Always Free Autonomous Database with quarterly updates.

AI-written summary · about

" chapters (11)

1. 0:00Intro
2. 0:40What is SQL Developer Web
3. 1:45Where can I find SQL Developer Web
4. 3:22Preferences
5. 4:05Code Palette
6. 4:56File Loading
7. 6:00PLSQL Editor
8. 10:21Demo
9. 11:59Diagrams
10. 15:45REST APIs
11. 17:33PLSQL

" related talks

• 33mTips and tricks for the Oracle Database developerJeff Smith · Oracle CloudWorld 2022
• 33mTips and tricks for SQL Developer and SQL Developer command lineJeff Smith · Oracle DatabaseWorld 2021
• 34mQuery any database in Oracle Cloud using your favorite web browserJeff Smith · Oracle CloudWorld 2022
• 32mModern application development with REST Data ServicesJiadong Chen · Oracle DatabaseWorld 2021
• 28mAPI-driven development and low-code REST APIsChris Hoina · Oracle CloudWorld 2022
• 44mWho is Jason, and what’s he doing in my database?Martin Bach · Voxxed Days Zürich 2024
• 21mDBeaver: efficient way to work with SQL and NoSQL from Eclipse IDETatiana Krupenya, Serge Rider · EclipseCon Europe 2018
• 15mPlug-and-Play for JSON and MongoDB DevelopersBEDA HAMMERSCHMIDT · Oracle DatabaseWorld: Multicloud AI Edition 2025