sal_diff); END; / Because this is a new record, old salary is not available and the above result comes as null.
Using the dbms_session package to identify individual users is the topic discussed in the next section.
In Oracle, truncating a table is a fast way to clear out records from a table if you don't need to worry about rolling back.
Notice how the action is amended regularly using the set_action procedure to make sure the action column of the v$session view stays accurate.
The set_client_info procedure allows information to be stored in the client_info column of the v$session view.
Truncating a table is also a lot easier than dropping the table and recreating it.
When a program initiates, it should register itself by implementing the set_module procedure to indicate that it is currently using the session.
The module_name parameter is used to specify the program name, while the action_name parameter is used to indicate current program activity.
This temporary work area is used to store the data retrieved from the database, and manipulate this data.
A cursor can hold more than one row, but can process only one row at a time.