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 Jeff.d.smith@oracle.com 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. Generic Login URL /ords/sql-developer 7

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

    • Environment • Version of Oracle • Database USER privs 8
  9. Usability Features: Mega Menu 9

  10. Help & Docs Help 10 In-App Help Oracle Docs

  11. Guided On-Screen Tours Application Tour 11

  12. Language (9) Support 12

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

    Exports • Editor Assistance • Formatting • Insight • Parser • SQL History • Command Palete 13
  14. 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
  15. SQL: full featured editor 15

  16. Data Grids • Click to Sort • Single Record View

    • Advanced Export • Type Viewers 16
  17. Grids: Single Record View 17 Columnar vs Row Display

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

    Apply Multiple Sort Conditions 18
  19. Grid: Type Viewers Click Cell Pencil to Activate 19 Dates/Timestamps

    Intervals BLOBs
  20. Grid: Exports Right Click, Export 20

  21. Worksheet - Queries • Automatic Formatting • SQL*Plus Style Reports

    • Same shortcut as desktop (F5) 21 Script Execution
  22. Worksheet: Explain Plan & AutoTrace 22

  23. Worksheet Assistance: SQL History Previous Queries/Scripts Executed 23

  24. Worksheet Assistance: Insight CTRL+Space to Invoke 24

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

    Advice 25
  26. Worksheet Assistance: Formatter 26 Before After

  27. Worksheet: Browser 27

  28. Worksheet: Browser • Search • Context menus • Drag ‘n’

    Drop 28 All Objects: Fuzzy Search
  29. Worksheet: Browser PL/SQL – Browse and Generate Anon Exec Blocks

    29
  30. Worksheet: Browser Create Table 30 Video Demonstration

  31. Worksheet: Browser Edit Table 31

  32. Worksheet: Browser Import data to NEW or Existing TABLEs +

    JSON + XML + AVRO + CSV + Excel 32
  33. Worksheet: Browser 33 Importing JSON to a Relational Table

  34. Charting 34 Take SQL query results and create rich HTML

    charts | combine for dashboards
  35. Creating a Chart 35 Just supply the SQL

  36. Dashboards 36 Take your favorite charts and combine in any

    order/grouping you want
  37. Charting: Getting Started 37 Promote Query from SQL worksheet

  38. User Management 38

  39. User Management, Create/Edit Users 39

  40. Instance Viewer 40

  41. Instance Viewer, Memory/Storage 41

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

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

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

  45. Activity/DBA Sessions Drill Down 45

  46. Activity/DBA Alerts Drill Down 46

  47. Activity/DBA TOP SQL Drill Down 47

  48. DBA Parameters 48

  49. Activity/DBA Performance Hub 49

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

  51. Data Modeler Automatic and STAR Schema Layouts 51

  52. Data Modeler Implied Foreign Keys 52

  53. Data Modeler Customize Objects, Relationships, Colors 53

  54. Data Modeler DDL Generation 54

  55. Data Modeler Data Dictionary Reports 55

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

    • Search Diagrams, Preview before opening 56 Managing Your Diagrams
  57. 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)
  58. REST 58 Full RESTful Web Service Development Interface

  59. REST Dashboard 59

  60. Browse, Edit, Create Modules 60

  61. Cards vs Grids 61 All browsers supports both views

  62. Templates 62

  63. Handlers 63

  64. REST IDE 64

  65. Parameters 65

  66. OAUTH2 66

  67. Creating OAUTH2 Clients 67

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

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

    query, data guides
  70. JSON – Add Document 70

  71. JSON Editor 71

  72. JSON – Filtering (Query by Example) 72

  73. JSON Filtering, get the SQL! 73

  74. JSON Data Guide (Diagram) 74

  75. JSON – Create INDEX or VIEW 75

  76. Data Pump 76 Monitor jobs, check logs, download DMP files

  77. Scheduling 77 Reporting for DBMS_SCHEDULER, Job Forecasting, & Chain Diagramming

  78. APEX Workspace Management 78 Create, Delete, Get URL, Navigate to

    SCHEMA
  79. Watch the Movie 79 50 Minute Video Tour https://www.youtube.com/watch?v=szqH2r-6KzU

  80. Thank You! Questions? Contact me! Jeff Smith Email: Jeff.d.d.smith@oracle.com Twitter:

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