Erik van Roon

SQLcl - SQL*Plus with benefits

Erik van Roon

Do you like working from the command line in sqlplus? Then you will love doing so in SQLcl. You don't like working from the command line, but have to? Then you will like it a lot more in SQLcl.

SQLcl (previously named SDSQL) is the command line tool that is built by the same team that brings us the GUI SQL Developer. It does (almost) everything SQL*Plus does, but on top of that lots and lots more. For example: easy csv creation and loading, querying data from another database without a database link, aliases, repeating queries a set number of times, generating ddl scripts, liquibase support, scripting with e.g. javascript and much more.

New features constantly get added, which alone is more than we were able to say about sql*plus for a long time This session will introduce SQLcl and show its features to those that are new to it.

Informacije o predavanju

Jezik / Language: ENG

O Avtorju

Erik van Roon is an Oracle Database Developer and Oracle ACE who has worked with Oracle technology since 1995, specializing in, but not limiting to, SQL and PLSQL. Since 2009 he is self-employed. His company is called EvROCS. Prior to that he has worked for several consulting companies in the Netherlands. He has worked on major projects for several clients in industries like entertainment, banking and energy. Erik has been the technical lead of multiple successful high impact data-migration projects moving and transforming large amounts of data. He's been a speaker at several conferences in Europe and the United states.

  • # SQL