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

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