Oracle SQL Developer Web - All the Features

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