Yesterday I wrote about execute sql script from plsql. Connor then posted a 12c new feature that I overviewed Or perhaps just use scheduler to run them, job_type = SQL_SCRIPT — Connor loves SQL , 🍸and ☕️ (@connor_mc_d) December 21, 2016 If you are still considering the 11g approach with sqlplus, you should read about […]
Month: December 2016
execute sql script from pl/sql
When you want to run a SQL script, you rather use sqlplus. If you want to run it within a PL/SQL stored procedure, you are screwed. You could redo the logic of sqlplus, this is what any decent IDE and code runnner does, and it’s a pile of work and you will get lot’s of […]
ANNOUNCEMENT: 12cR2 documentation is available
The doc docs.oracle.com/database/122 is available. Check new features and stay tuned. Okay, just 12 for today : HIGH compressed index, case insensitive database with bound collation, partitioned external tables, AL32UTF8 default for new database, listagg overflow, VALIDATE_CONVERSION, approx_percentile, json_exists, flashback pluggable database, the SHARING clause, RAC streched clusters site definition and INACTIVE_ACCOUNT_TIME in profile. Some […]