$30 off During Our Annual Pro Sale. View Details »

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 Jeff.d.smith@oracle.com 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. 7 Start Here /ords/sql-developer Copyright @ 2022 Oracle and/or its

    affliates
  8. 8 Database Actions • “Launchpad”/Home • Access to features determined

    by: • Environment • Version of Oracle • Database USER privs Copyright @ 2022 Oracle and/or its affliates
  9. 9 Usability Features: Mega Menu Copyright @ 2022 Oracle and/or

    its affliates
  10. 10 Help & Docs In-App Help Oracle Docs Copyright @

    2022 Oracle and/or its affliates
  11. 11 Guided On-Screen Tours Application Tour Copyright @ 2022 Oracle

    and/or its affliates
  12. 12 Language (9) Support Copyright @ 2022 Oracle and/or its

    affliates
  13. 13 SQL • Queries & Scripts • Tuning • Imports

    & Exports • Editor Assistance • Formatting • Insight • Parser • SQL History • Command Palette Copyright @ 2022 Oracle and/or its affliates
  14. 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
  15. 15 SQL: full featured editor Copyright @ 2022 Oracle and/or

    its affliates
  16. 16 Data Grids • Click to Sort • Single Record

    View • Advanced Export • Type Viewers Copyright @ 2022 Oracle and/or its affliates
  17. 17 Grids: Single Record View Columnar vs Row Displays Copyright

    @ 2022 Oracle and/or its affliates
  18. 18 Grids: Manage Columns & Sorts Hide & Reorder Columns

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

    Intervals BLOBs Copyright @ 2022 Oracle and/or its affliates
  20. 20 Grid: Exports Right Click, Export Copyright @ 2022 Oracle

    and/or its affliates
  21. 21 Worksheet - Queries Script Execution • Automatic Formatting •

    SQL*Plus Style Reports • Same shortcut as desktop (F5) Copyright @ 2022 Oracle and/or its affliates
  22. 22 Worksheet: Execution Plans Copyright @ 2022 Oracle and/or its

    affliates
  23. 23 Worksheet: AutoTrace Copyright @ 2022 Oracle and/or its affliates

  24. 24 Worksheet Assistance: SQL History Previous Queries/Scripts Executed Copyright @

    2022 Oracle and/or its affliates
  25. 25 Worksheet Assistance: Insight CTRL+Space Copyright @ 2022 Oracle and/or

    its affliates
  26. 26 Worksheet Assistance: Parser Mouse Over Gutter or Grammar Squiggles

    for Advice Copyright @ 2022 Oracle and/or its affliates
  27. 27 Worksheet Assistance: Formatter Before After Copyright @ 2022 Oracle

    and/or its affliates
  28. 28 Worksheet: Browser Drag and Drop Code Generation Copyright @

    2022 Oracle and/or its affliates
  29. 29 Worksheet: PL/SQL Browse and Generate Anon Exec Blocks Copyright

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

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

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

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

    your local machine Copyright @ 2022 Oracle and/or its affliates
  34. 34 Worksheet: Schema Browser Create Table Video Demonstration Copyright @

    2022 Oracle and/or its affliates
  35. 35 Worksheet: Schema Browser Edit Table Copyright @ 2022 Oracle

    and/or its affliates
  36. 36 Worksheet: Schema Browser Open Table Copyright @ 2022 Oracle

    and/or its affliates
  37. 37 Worksheet: Schema Browser SEARCH Copyright @ 2022 Oracle and/or

    its affliates
  38. 38 Worksheet: Data Loading Import data to NEW or Existing

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

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

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

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

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

    order/grouping you want Copyright @ 2022 Oracle and/or its affliates
  44. 44 Charting: Getting Started Promote Query from SQL worksheet Copyright

    @ 2022 Oracle and/or its affliates
  45. 45 User Management Copyright @ 2022 Oracle and/or its affliates

  46. 46 User Management, Create/Edit Users Copyright @ 2022 Oracle and/or

    its affliates
  47. 47 Instance Viewer Copyright @ 2022 Oracle and/or its affliates

  48. 48 Instance Viewer, Memory/Storage Copyright @ 2022 Oracle and/or its

    affliates
  49. 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
  50. 50 Activity/DBA Storage Drill Down Copyright @ 2022 Oracle and/or

    its affliates
  51. 51 Activity/DBA Storage Drill Down/View Data Files Copyright @ 2022

    Oracle and/or its affliates
  52. 52 Activity/DBA Sessions Drill Down Copyright @ 2022 Oracle and/or

    its affliates
  53. 53 Activity/DBA Alerts Drill Down Copyright @ 2022 Oracle and/or

    its affliates
  54. 54 Activity/DBA TOP SQL Drill Down Copyright @ 2022 Oracle

    and/or its affliates
  55. 55 DBA Parameters Copyright @ 2022 Oracle and/or its affliates

  56. 56 Activity/DBA Performance Hub Copyright @ 2022 Oracle and/or its

    affliates
  57. 57 Data Modeler Reverse Engineer/Diagrams from your SCHEMA Video Demonstration

    Copyright @ 2022 Oracle and/or its affliates
  58. 58 Data Modeler Automatic and STAR Schema Layouts Copyright @

    2022 Oracle and/or its affliates
  59. 59 Data Modeler Implied Foreign Keys Copyright @ 2022 Oracle

    and/or its affliates
  60. 60 Data Modeler Customize Objects, Relationships, Colors Copyright @ 2022

    Oracle and/or its affliates
  61. 61 Data Modeler DDL Generation Copyright @ 2022 Oracle and/or

    its affliates
  62. 62 Data Modeler Data Dictionary Reports Copyright @ 2022 Oracle

    and/or its affliates
  63. 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
  64. 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
  65. 65 REST Full RESTful Web Service Development Interface Copyright @

    2022 Oracle and/or its affliates
  66. 66 REST Dashboard Copyright @ 2022 Oracle and/or its affliates

  67. 67 Browse, Edit, Create Modules Copyright @ 2022 Oracle and/or

    its affliates
  68. 68 Cards vs Grids All browsers supports both views Copyright

    @ 2022 Oracle and/or its affliates
  69. 69 URI Templates Copyright @ 2022 Oracle and/or its affliates

  70. 70 HTTP Handlers Copyright @ 2022 Oracle and/or its affliates

  71. 71 REST IDE Copyright @ 2022 Oracle and/or its affliates

  72. 72 Parameters Copyright @ 2022 Oracle and/or its affliates

  73. 73 OAUTH2 Copyright @ 2022 Oracle and/or its affliates

  74. 74 Creating OAUTH2 Clients Copyright @ 2022 Oracle and/or its

    affliates
  75. 75 ‘Show Code’ Copyright @ 2022 Oracle and/or its affliates

  76. 76 Documentation & Testing Built-in OpenAPI3 {swagger} clients & doc

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

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

    query, data guides Copyright @ 2022 Oracle and/or its affliates
  79. 79 JSON – Add Document Copyright @ 2022 Oracle and/or

    its affliates
  80. 80 JSON Editor Copyright @ 2022 Oracle and/or its affliates

  81. 81 JSON – Filtering (Query by Example) Copyright @ 2022

    Oracle and/or its affliates
  82. 82 JSON Filtering, get the SQL! Copyright @ 2022 Oracle

    and/or its affliates
  83. 83 JSON Data Guide (Diagram) Copyright @ 2022 Oracle and/or

    its affliates
  84. 84 JSON – Create INDEX or VIEW Copyright @ 2022

    Oracle and/or its affliates
  85. 85 Data Pump IMPORT – Autonomous and On Premises Support

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

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

    more! Copyright @ 2022 Oracle and/or its affliates
  88. 88 DBMS_SCHEDULER Reporting, Job Forecasting, & Chain Diagramming Copyright @

    2022 Oracle and/or its affliates
  89. 89 APEX Workspace Management Create, Delete, Get URL, Navigate to

    SCHEMA Copyright @ 2022 Oracle and/or its affliates
  90. 90 Watch the Movie 50 Minute Video Tour https://www.youtube.com/watch?v=szqH2r-6KzU Copyright

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

    Email: Jeff.d.d.smith@oracle.com Twitter: @thatjeffsmith Blog: https://www.thatjeffsmith.com Thank You! Questions?