Rowe IT – Oracle PL/SQL and SQL Tips

Package Variable Scope

Posted on March 16, 2022March 16, 2022 by admin

Package public variables and cursors can persist for the life of a session, per “Added Functionality” 103EB8529FD5https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-packages.html#GUID-F2763E50-C2C6-4A4B-AEFA-103EB8529FD5

Session-Based Application Context

Posted on March 16, 2022March 16, 2022 by admin

A database session-based application context retrieves and sets data for the context https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/using-application-contexts-to-retrieve-user-information.html#GUID-F0968CAC-E281-4C45-BCF7-7DB157A322D1

Hello world!

Posted on June 12, 2021June 12, 2021 by admin

I intend to to provide some sample scripts to inform and/or provide some insight into features that are available within Oracle PL/SQL. I simply wanted a place to place the scripts that I have put together so I can find them and so can others.