This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Erik van Roon

SQLcl - SQL*Plus with Benefits, plus Calling PLSQL from SQL since 12c


Erik van Roon, EvROCS


 

Abstract

This presentation will deal with two subjects.
First there will be an introduction to SQLcl.
SQLcl is the new command line tool for doing SQL.
It does everything SQL*Plus does, and lots 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 most important features to those that are new to it.

Second we'll have a look at the improvements since Oracle database 12c with respect to calling user defined functions from sql.
Now the WITH clause can include definitions of PL/SQL-functions for use inside your query, and then there is the option to use the udf pragma to compile functions for use in SQL.
Both features will be shown, including some pitfalls and the difference in performance, compared to each other and to using conventional function calls.

 
Speaker Biography

Erik van Roon is an Oracle Developer 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, working with the classic Oracle tools Designer, Forms, Reports, and of course SQL and PLSQL.. Erik has been the technical lead of multiple successful high impact data-migration projects moving and transforming large amounts of data. Since 2012 every year Erik builds and makes available the ero$kscope_sessions package that allows you to *query* the presentations on that years KScope site Erik has had the pleasure of speaking at conferences like ODTUG's KScope, NLOUG Tech Experience in the Netherlands, the Polish conference by POUG and the Bulgarian one by BGOUG. In 2015 Erik was nominated and selected to be a finalist in the SQL category of OTN Developers Choice Awards.