Tag Archives: quicktip

#Oracle #SQLcl #quicktip

Posted on December 24, 2020 by rlockard

If you’re not following Jeff Smith and Kris Rice, you should be. These are two really smart guys, who are designing the tools we use everyday to do our jobs. If you’re like me, 99% of your data is in … Continue reading →

Posted in Database Stuff | Tagged quicktip | Leave a comment

Update to my earlier #quicktip on setting #plsql scope and warnings.

Posted on February 23, 2018 by rlockard

I noticed a error in my code for setting PLSCOPE_SETTINGS and PLSQL_WARNINGS. QuicTip Logon.sql What I did was get the instance name out of v$instance to figure out if I was connecting to a production environment or one of the lower environments. The … Continue reading →

Posted in Database Stuff, Life of a Oracle DBA, PL/SQL | Tagged logon.sql, oracle, pl/sql, PLSCOPE, PLSCOPE_SETTINGS, PLSQL_WARNINGS, quick tip, quicktip, sys_context | Leave a comment