Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...

This article focuses on triggers, essential components in database management. Triggers are procedures that are automatically executed in response to certain events in a database. They are integral to ...

Some data could be so sensitive, than neither the system nor sys user can see them. But those guys have to see everything! Then how? I found a simple and easy way to manage these kind of data. Follow ...

Database auditing is the activity of monitoring and recording configured database actions from database users and nondatabase users, to ensure the security of the databases. An administrator can ...

Application contexts enable you to store data in memory for applications to use. The After Logon database trigger is a convenient way to initialize a user session by setting application context values ...