Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Oracle SQL Developer Web - All the Features

Oracle SQL Developer Web - All the Features

Screenshots of all of the features in Oracle SQL Developer Web version 21.3 plus a sneak-peek at features due later this month.

Allows designers, developers, DBAs, and business analysts to work with their Oracle Database.

SQL Developer Web is a feature provided by Oracle REST Data Services (ORDS).

thatjeffsmith

November 24, 2020
Tweet

More Decks by thatjeffsmith

Other Decks in Programming

Transcript

  1. Jeff Smith 1 Oracle SQL Developer Web Database Actions Distinguished

    Product Manager [email protected] https://www.thatjeffsmith.com || @thatjeffsmith
  2. • SQL Worksheet • Charts • Schema Browser • Performance

    & Instance Management • Diagramming/Dictionary Reports • JSON Document IDE • REST IDE • User Management • Data Loading • Scheduling • APEX Workspace Management 2 SQL Developer Web The power of SQL Developer…in your browser
  3. How It Works • Delivered via ORDS Plugin • HTML,

    JS, Oracle JET • DB User Authentication via REST Enabled Schemas 3
  4. Installation & Configuration • Install ORDS • Say “YES” to

    SQL Developer Web Video Tutorial: https://www.youtube.com/watch?v=1LBmLTe8sIc 4 You can use SQL Developer anywhere you can run ORDS
  5. SQLDev Web & Autonomous Database • Service Console • ADMIN

    SSO • Updated Quarterly • ORDS is managed by Oracle 5
  6. Database Logins • Database User/Password • REST Enable SCHEMAs •

    ADMIN enabled by default in Autonomous DB 6 ORDS API – ENABLE SCHEMA
  7. Database Actions • “Launchpad”/Home • Access to features determined by:

    • Environment • Version of Oracle • Database USER privs 8
  8. SQL • Queries & Scripts • Tuning • Imports &

    Exports • Editor Assistance • Formatting • Insight • Parser • SQL History • Command Palete 13
  9. SQL • Same Keyboard Shortcuts, e.g., CTRL+ENTER • Grid or

    text presentation • SQL*Plus Script Engine Support • Quick Download Popular Formats • CSV, JSON, XML, TEXT 14 Query Execution
  10. Data Grids • Click to Sort • Single Record View

    • Advanced Export • Type Viewers 16
  11. Grids: Manage Columns & Sorts Hide & Reorder Columns &

    Apply Multiple Sort Conditions 18
  12. Worksheet - Queries • Automatic Formatting • SQL*Plus Style Reports

    • Same shortcut as desktop (F5) 21 Script Execution
  13. Activity/DBA • DB Status • Storage • Sessions • Waits

    • Users • Expired PWDs • Alerts • Top SQL 42 Instance Overview and Performance Pages
  14. Data Modeler • Save Diagrams (stored in local database TABLE)

    • Search Diagrams, Preview before opening 56 Managing Your Diagrams
  15. Data Modeler • Open Diagrams from Oracle SQL Developer Data

    Modeler • And Vice Versa! 57 Desktop Integration Built in SQL Developer Web Built in SQL Developer Data Modeler (Desktop)
  16. Thank You! Questions? Contact me! Jeff Smith Email: [email protected] Twitter:

    @thatjeffsmith Blog: https://www.thatjeffsmith.com 80