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.

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
   

   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: Jeff.d.d.smith@oracle.com
    Twitter: @thatjeffsmith
    Blog: https://www.thatjeffsmith.com
    Thank You!
    Questions?
    

    View Slide