alter session set current_schema=scott : current_schema « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. current_schema
SQL>
SQL>
SQL>
SQL> alter session set current_schema=scott;
ERROR:
ORA-01435: user does not exist


SQL> show user
USER is "JAVA2S"
SQL>








29.39.current_schema
29.39.1.alter session set current_schema=scott