Oracle Database Tools

Single slide descriptions/highlights for Oracle SQL Developer, SQLcl, Data Modeler, ORDS, and SQL Developer Web.

Transcript

1. 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
2. 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
3. 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
4. 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
5. 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