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

Oracle SQL Developer Web - All the Features

0ed10d1154c696886ca483fe827cb299?s=47 thatjeffsmith
November 24, 2020

Oracle SQL Developer Web - All the Features

Screenshots of all of the features in Oracle SQL Developer Web version 20.3.

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).

0ed10d1154c696886ca483fe827cb299?s=128

thatjeffsmith

November 24, 2020
Tweet

Transcript

  1. Jeff Smith 1 Oracle SQL Developer Web Distinguished Product Manager

    Jeff.d.smith@oracle.com https://www.thatjeffsmith.com || @thatjeffsmith
  2. • SQL Worksheet • Database Object Editors/Browsing • Performance &

    Instance Management • Relational Diagrams/Data Dictionary Reports • JSON Document management and reporting • REST Development Interface • User Management • Importing Data – CSV, XML, AVRO, JSON 2 SQL Developer Web The power of SQL Developer…in your browser
  3. How It Works • REST Endpoints backed by ORDS •

    Database User Authentication via REST Enabled Schemas • SQL Developer Web is an ORDS Plugin: • HTML, JavaScript, & Oracle JET Interface • Supported in all modern browsers 3
  4. Installation & Configuration Install ORDS 19.4 Say “YES” to SQL

    Developer Web 4 For On-Premise Deployments
  5. Accessing SQL Developer Web from Autonomous • Console Link •

    Bookmark the URL 5
  6. Getting Started • Database User/Password • REST Enable SCHEMAs •

    ADMIN enabled by default in ADB 6
  7. Login URL 7

  8. Database Actions • Role based access • ADB vs On-Premises

    8
  9. Usability Features Help 9 In-App Help Oracle Docs

  10. Usability Features - Tours Application Tour 10

  11. Usability Features: Language (9) Support 11

  12. SQL • Queries & Scripts • Tuning • Imports &

    Exports • Editor Assistance • Formatting • Insight • Parser • SQL History 12
  13. SQL • Same KB (Ctrl+Enter) • Paged Results • Grid

    Display • Quick Download Popular Formats • CSV, JSON, XML, TEXT 13 Query Execution
  14. Data Grids • Click to Sort • Single Record View

    • Advanced Export • Type Viewers 14
  15. Grids: Single Record View 15 Columnar vs Row Display

  16. Grids: Manage Columns & Sorts Hide & Reorder Columns &

    Apply Multiple Sort Conditions 16
  17. Grid: Type Viewers Click Cell Pencil to Activate 17

  18. Grid: Exports Right Click, Export 18

  19. Worksheet - Queries • Same KB (F5) • All Results

    Fetched • Multiple Statements • Output Formatted 19 Script Execute
  20. Worksheet: Tuning Explain Plan 20

  21. Worksheet: Tuning • Get Session Stats • Run Query •

    Get Session Stats • Print Stats Delta & Plan (V$SQL_PLAN) 21 AutoTrace
  22. Worksheet Assistance: SQL History Previous Queries/Scripts Ran in your Browser

    22
  23. Worksheet Assistance: Insight Ctrl+Spacebar to Activate 23

  24. Worksheet Assistance: Parser Mouse Over Gutter or Grammar Squiggles for

    Advice 24
  25. Worksheet Assistance: Formatter Runs in Browser (js) 25 Before After

  26. Worksheet: Browser See, Create & Edit 26

  27. Worksheet: Browser • Search across all schema object types •

    Context Menus for each object • Drag and Drop Support to Worksheet 27 All Objects: Fuzzy Search
  28. Worksheet: Browser PL/SQL – Browse and Generate Anon Exec Blocks

    28
  29. Worksheet: Browser Create Table 29 Video Demonstration

  30. Worksheet: Browser Edit Table 30

  31. Worksheet: Browser Create View 31

  32. Worksheet: Browser Create Materialized View 32

  33. Worksheet: Browser Create Synonym 33

  34. Worksheet: Browser Create Index 34

  35. Worksheet: Browser Create Sequence 35

  36. Worksheet: Browser Excel/CSV Imports + json + xml + avro

    36
  37. Worksheet: Browser 37 Importing JSON to a Relational Table

  38. Worksheet Browser • Tables • Views • Indexes • MVs

    • Sequences • Synonyms Coming Soon PL/SQL, DDL, Data 38 Opening Objects (View Metadata)
  39. User Management 39

  40. User Management, Create/Edit Users 40

  41. Instance Viewer 41

  42. Instance Viewer, Memory/Storage 42

  43. Activity/DBA • DB Status • Storage • Sessions • Waits

    • Users • Expired PWDs • Alerts • Top SQL 43 Instance Overview and Performance Pages
  44. Activity/DBA Status Drill Down 44

  45. Activity/DBA Storage Drill Down 45

  46. Activity/DBA Storage Drill Down/View Data Files 46

  47. Activity/DBA Sessions Drill Down 47

  48. Activity/DBA Alerts Drill Down 48

  49. Activity/DBA TOP SQL Drill Down 49

  50. DBA Parameters 50

  51. Activity/DBA Performance Hub 51

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

  53. Data Modeler Automatic and STAR Schema Layouts 53

  54. Data Modeler Implied Foreign Keys 54

  55. Data Modeler Customize Objects, Relationships, Colors 55

  56. Data Modeler DDL Generation 56

  57. Data Modeler Data Dictionary Reports 57

  58. Data Modeler • Save Diagrams (stored in local database TABLE)

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

    Modeler • And Vice Versa! 59 Desktop Integration Built in SQL Developer Web Built in SQL Developer Data Modeler (Desktop)
  60. REST 60 Full RESTful Web Service Development Interface

  61. REST Dashboard 61

  62. Browse, Edit, Create Modules 62

  63. Cards vs Grids 63 All browsers supports both views

  64. Templates 64

  65. Handlers 65

  66. Detailed Handler Editor 66

  67. Parameters 67

  68. OAUTH2 68

  69. Creating OAUTH2 Clients 69

  70. JSON 70 JSON Document Store – Create collections, manage documents,

    QBE, Data Guides
  71. JSON – Create Collection 71

  72. JSON – Add Document 72

  73. JSON Editor 73 Form, View, Text, Tree + a JSON

    Parser
  74. JSON – Query By Example 74

  75. JSON Data Guide (Diagram) 75

  76. What’s Next? • AUTO REST Support • Data Grids for

    Table viewers (read only) • JSON in Autonomous • PL/SQL Code Editors • Reports • More Data Loading 76 Features Planned for Q4-2020 Features Planned for 2021
  77. Thank You! Questions? Jeff Smith Jeff.d.d.smith@oracle.com @thatjeffsmith 77