Slide 1

Slide 1 text

SQL Developer • Run SQL statements • Load data • Database development • Monitor and manage • Data modeling – ERD • REST services development • Migrate 3rd party DMBS to Oracle • No cost https://www.oracle.com/sqldeveloper Used by over 5 million database pros

Slide 2

Slide 2 text

SQL Developer Web • Your favorite tool, in the browser • Load data - excel, csv, avro, xml… • Run SQL statements & scripts • Monitor and manage • Schema diagramming • No cost https://www.oracle.com/rest

Slide 3

Slide 3 text

SQL Developer Data Modeler • Industry leading design tool • Logical and Relational • ERD’s • SVN & Git integration • Reporting • DDL Generation • Compare and Synch • No cost https://www.oracle.com/database/technologies/appdev/sql-developer.html

Slide 4

Slide 4 text

SQLcl • Modern command-line interface • Auto complete SQL syntax • Command history • Output json, csv, html, inserts, xml… • Liquibase schema lifecycle integration • Scripting friendly • No Oracle Home required https://www.oracle.com/database/technologies/appdev/sqlcl.html SQL Command Line

Slide 5

Slide 5 text

Oracle REST Data Services • Microservices for your Oracle Database • Declaratively defined using SQL, PL/SQL • Define via PL/SQL API, SQL Dev or APEX • Auto REST enable tables and views • Create custom REST services • All datatypes including spatial • Document Store REST API • Conforms to Oracle JSON standards https://www.oracle.com/rest HTTPS Results JSON SQL Meta Data Repo