What is ALTER SESSION statement?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is ALTER SESSION statement?
Rating:
The ALTER SESSION statement is used to set the initialization parameters that are dynamic in nature. Such parameters can be set for an ongoing user session without terminating or restarting the session. The SET clause of the ALTER SESSION statement is used for setting the parameter values.
However, the changes incorporated using the ALTER SESSION statement are valid only till the current session is active.
Rating:
Was this information helpful?
Other articles
- What is the Undo Advisor?
- Things to practice for Oracle test 1Z0-043.
- What is the DISTINCT clause?
- What is pending area?
- What is a tablespace?