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

Oracle SQL Developer Web: 2022 Features

Oracle SQL Developer Web: 2022 Features

Overview of everything Oracle SQL Developer Web, also known as Database Actions, offers to the Oracle Database developer, DBA, or business analyst.

Plenty of screenshots so you can get a really good idea of what's capable simply by opening your favorite web browser.

thatjeffsmith

October 04, 2022
Tweet

More Decks by thatjeffsmith

Other Decks in Programming

Transcript

  1. 1 Copyright @ 2022 Oracle and/or its affliates Oracle SQL

    Developer Web Database Actions Jeff Smith Distinguished Product Manager [email protected] Blog: https://www.thatjeffsmith.com Twitter: @thatjeffsmith
  2. 2 SQL Developer Web The power of SQL Developer…in your

    browser • SQL Worksheet – SQL, PLSQL, MLE/JS • Charts & Dashboarding • Schema Browser • Performance & Instance Management • Diagramming/Dictionary Reports • JSON Document Management • REST Workshop • User Management • Data Loading / Data Pump • DBMS Scheduler • APEX Workspace Management Copyright @ 2022 Oracle and/or its affliates
  3. 3 How It Works Standalone or Java Servlet (Tomcat or

    WLS) DB User Authentication for REST Enabled Schemas ORDS Served REST APIs Oracle JET Single Page Web App Copyright @ 2022 Oracle and/or its affliates
  4. 4 Installation & Configuration You can use SQL Developer anywhere

    you can run ORDS • Install ORDS • Say “YES” to SQL Developer Web Video Tutorial https://www.youtube.com/watch?v=1LBmLTe8sIc Copyright @ 2022 Oracle and/or its affliates
  5. 5 SQLDev Web & Autonomous Database • ADMIN SSO •

    Updated Quarterly • ORDS is managed by Oracle Copyright @ 2022 Oracle and/or its affliates
  6. 6 Database Logins • Database User/Password • REST Enable SCHEMAs

    • ADMIN enabled by default in Autonomous DB ORDS API – ENABLE SCHEMA Copyright @ 2022 Oracle and/or its affliates
  7. 8 Database Actions • “Launchpad”/Home • Access to features determined

    by: • Environment • Version of Oracle • Database USER privs Copyright @ 2022 Oracle and/or its affliates
  8. 10 Help & Docs In-App Help Oracle Docs Copyright @

    2022 Oracle and/or its affliates
  9. 13 SQL • Queries & Scripts • Tuning • Imports

    & Exports • Editor Assistance • Formatting • Insight • Parser • SQL History • Command Palette Copyright @ 2022 Oracle and/or its affliates
  10. 14 SQL Query Execution • Same Keyboard Shortcuts, e.g., CTRL+ENTER

    • Grid or text presentation • SQL*Plus Script Engine Support • Quick Download Popular Formats • CSV, JSON, XML, TEXT Copyright @ 2022 Oracle and/or its affliates
  11. 16 Data Grids • Click to Sort • Single Record

    View • Advanced Export • Type Viewers Copyright @ 2022 Oracle and/or its affliates
  12. 18 Grids: Manage Columns & Sorts Hide & Reorder Columns

    & Apply Multiple Sort Conditions Copyright @ 2022 Oracle and/or its affliates
  13. 19 Grid: Type Viewers Click Cell Pencil to Activate Dates/Timestamps

    Intervals BLOBs Copyright @ 2022 Oracle and/or its affliates
  14. 21 Worksheet - Queries Script Execution • Automatic Formatting •

    SQL*Plus Style Reports • Same shortcut as desktop (F5) Copyright @ 2022 Oracle and/or its affliates
  15. 26 Worksheet Assistance: Parser Mouse Over Gutter or Grammar Squiggles

    for Advice Copyright @ 2022 Oracle and/or its affliates
  16. 30 Worksheet: PL/SQL Open and Edit/Compile in a Full Screen

    Editor Copyright @ 2022 Oracle and/or its affliates
  17. 31 Worksheet: JavaScript Powered by Multilingual Engine (MLE) and GraalVM

    in Database 21c Copyright @ 2022 Oracle and/or its affliates
  18. 32 Worksheet: JavaScript Powered by Multilingual Engine (MLE) and GraalVM

    in Database 21c Copyright @ 2022 Oracle and/or its affliates
  19. 33 Worksheet: Local File Editing Open and Save Files from

    your local machine Copyright @ 2022 Oracle and/or its affliates
  20. 38 Worksheet: Data Loading Import data to NEW or Existing

    TABLEs + JSON + XML + AVRO + CSV + Excel Copyright @ 2022 Oracle and/or its affliates
  21. 39 Worksheet: Data Loading Add multiple files, create multiple tables

    all in one go! Copyright @ 2022 Oracle and/or its affliates
  22. 40 Worksheet: Data Loading Importing JSON to a Relational Table

    Copyright @ 2022 Oracle and/or its affliates
  23. 41 Charts Take SQL query results and create rich HTML

    charts | combine for dashboards Copyright @ 2022 Oracle and/or its affliates
  24. 42 Creating a Chart Just supply the SQL Copyright @

    2022 Oracle and/or its affliates
  25. 43 Dashboards Take your favorite charts and combine in any

    order/grouping you want Copyright @ 2022 Oracle and/or its affliates
  26. 49 Activity/DBA Instance Overview and Performance Pages • DB Status

    • Storage • Sessions • Waits • Users • Expired PWDs • Alerts • Top SQL Copyright @ 2022 Oracle and/or its affliates
  27. 63 Data Modeler Managing Your Diagrams • Save Diagrams (stored

    in local database TABLE) • Search Diagrams, Preview before opening Copyright @ 2022 Oracle and/or its affliates
  28. 64 Data Modeler Desktop Integration • Open Diagrams from Oracle

    SQL Developer Data Modeler • And Vice Versa! Built in SQL Developer Web Built in SQL Developer Data Modeler (Desktop) Copyright @ 2022 Oracle and/or its affliates
  29. 76 Documentation & Testing Built-in OpenAPI3 {swagger} clients & doc

    Copyright @ 2022 Oracle and/or its affliates
  30. 77 Quickly Import from OpenAPI Take OpenAPI Spec definition to

    a fully built-out REST Module Copyright @ 2022 Oracle and/or its affliates
  31. 78 JSON JSON Document Store – Create collections, manage documents,

    query, data guides Copyright @ 2022 Oracle and/or its affliates
  32. 85 Data Pump IMPORT – Autonomous and On Premises Support

    Copyright @ 2022 Oracle and/or its affliates
  33. 86 Data Pump Monitor jobs, check logs, download DMP files

    Copyright @ 2022 Oracle and/or its affliates
  34. 87 DBMS_SCHEDULER Create and edit Jobs, Chains, Schedules, Windows, and

    more! Copyright @ 2022 Oracle and/or its affliates
  35. 89 APEX Workspace Management Create, Delete, Get URL, Navigate to

    SCHEMA Copyright @ 2022 Oracle and/or its affliates
  36. 91 Copyright @ 2022 Oracle and/or its affliates Jeff Smith

    Email: [email protected] Twitter: @thatjeffsmith Blog: https://www.thatjeffsmith.com Thank You! Questions?