Session Control Statements
Session control statements dynamically manage the properties of a user session.
A session is a logical entity in the database instance memory that represents the state of a current user login to a database. A session lasts from the time the user is authenticated by the database until the user disconnects or exits the database application.
visual studio net training courses malaysia
Session control statements enable you to:
Alter the current session by performing a specialized function, such as setting the default date format (
ALTER SESSION).microsoft system center certification training courses malaysia
Enable and disable roles, which are groups of privileges, for the current session (
SET ROLE).microsoft sql server certification training courses malaysia
The following statement dynamically changes the default date format for your session to 'YYYY MM DD-HH24:MI:SS':
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS';
Session control statements do not implicitly commit the current transaction.
microsoft sharepoint certification training courses malaysia
Comments
Post a Comment