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
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?