Tips and tricks for the Oracle Database developer

on YouTube ↗33m

" summary

Overview of concrete saves: browser-based Oracle SQL Developer Web plus desktop and SQLcl automate tedious steps — generate DDL with the command ddl employees, produce Liquibase change sets with the short command lb, and stream Data Pump dumps straight to OCI object storage using Data Pump to object store. Database 21c runs JavaScript in‑DB, ORDS delivers the web UI and REST endpoints, the file reader writes local files, and the JSON visualizer and search find schema pieces quickly; always‑free Autonomous allows two demo DBs.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 2:52Re-imagined as a Single Page Web Application
3. 10:12Tip: Use the Code Palette
4. 22:24SQLd, your modern Command Line Interface

" related talks

• 20mDatabase developer productivity tips and tricksJeff Smith · Oracle DatabaseWorld 2022
• 33mTips and tricks for SQL Developer and SQL Developer command lineJeff Smith · Oracle DatabaseWorld 2021
• 24mRethinking Database Architecture to Embrace Modern App DevJuan Loaiza · Oracle DatabaseWorld 2021
• 32mModern application development with REST Data ServicesJiadong Chen · Oracle DatabaseWorld 2021
• 23mHow to evolve your database applications entirely onlineLudovico Caldara · Oracle DatabaseWorld 2022
• 36mHow to make your daily routine, code and database more efficientMarcin Przepiorowski · Riga Dev Days 2019
• 30mSelf-service data warehousingPatrick Wheeler · Oracle DatabaseWorld 2021
• 21mDeep dive: Data loadingBud Endress · Oracle DatabaseWorld 2022