Oracle Database Tools

Oracle Database Tools

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

0ed10d1154c696886ca483fe827cb299?s=128

thatjeffsmith

October 08, 2020
Tweet

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