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

    View Slide

  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

    View Slide

  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

    View Slide

  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

    View Slide

  5. 5
    SQLDev Web & Autonomous Database
    • ADMIN SSO
    • Updated Quarterly
    • ORDS is managed
    by Oracle
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  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

    View Slide

  7. 7
    Start Here
    /ords/sql-developer
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  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

    View Slide

  9. 9
    Usability Features: Mega Menu
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  10. 10
    Help & Docs
    In-App Help Oracle Docs
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

  13. 13
    SQL
    • Queries & Scripts
    • Tuning
    • Imports & Exports
    • Editor Assistance
    • Formatting
    • Insight
    • Parser
    • SQL History
    • Command Palette
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  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

    View Slide

  15. 15
    SQL: full featured editor
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  16. 16
    Data Grids
    • Click to Sort
    • Single Record View
    • Advanced Export
    • Type Viewers
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

  18. 18
    Grids: Manage Columns & Sorts
    Hide & Reorder Columns & Apply Multiple Sort Conditions
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  19. 19
    Grid: Type Viewers
    Click Cell Pencil to Activate
    Dates/Timestamps
    Intervals
    BLOBs
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

  21. 21
    Worksheet - Queries
    Script Execution
    • Automatic Formatting
    • SQL*Plus Style Reports
    • Same shortcut as
    desktop (F5)
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  22. 22
    Worksheet: Execution Plans
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

  24. 24
    Worksheet Assistance: SQL History
    Previous Queries/Scripts Executed
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

  26. 26
    Worksheet Assistance: Parser
    Mouse Over Gutter or Grammar Squiggles for Advice
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  33. 33
    Worksheet: Local File Editing
    Open and Save Files from your local machine
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  38. 38
    Worksheet: Data Loading
    Import data to NEW or Existing TABLEs
    + JSON
    + XML
    + AVRO
    + CSV
    + Excel
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  39. 39
    Worksheet: Data Loading
    Add multiple files, create multiple tables all in one go!
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

  41. 41
    Charts
    Take SQL query results and create rich HTML charts | combine for dashboards
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  42. 42
    Creating a Chart
    Just supply the SQL
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  43. 43
    Dashboards
    Take your favorite charts and combine in any order/grouping you want
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  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

    View Slide

  50. 50
    Activity/DBA
    Storage Drill Down
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  57. 57
    Data Modeler
    Reverse Engineer/Diagrams from your SCHEMA
    Video Demonstration
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  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

    View Slide

  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

    View Slide

  65. 65
    REST
    Full RESTful Web Service Development Interface
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

  68. 68
    Cards vs Grids
    All browsers supports both views
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  76. 76
    Documentation & Testing
    Built-in OpenAPI3 {swagger} clients & doc
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  77. 77
    Quickly Import from OpenAPI
    Take OpenAPI Spec definition to a fully built-out REST Module
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  78. 78
    JSON
    JSON Document Store – Create collections, manage documents, query, data guides
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

  79. 79
    JSON – Add Document
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

  81. 81
    JSON – Filtering (Query by Example)
    Copyright @ 2022 Oracle and/or its affliates

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  91. 91 Copyright @ 2022 Oracle and/or its affliates
    Jeff Smith
    Email: [email protected]
    Twitter: @thatjeffsmith
    Blog: https://www.thatjeffsmith.com
    Thank You!
    Questions?

    View Slide