SYNTAX
X-SET SCHEMA schema_name ;
DESCRIPTION
X-SET SCHEMA command sets the schema name that will be
used by default in subsequent commands if object's schema is omitted.
After CONNECT command the default schema name is the name of the connected user.
Note the semicolon at the end.
The command implicitly executes "alter session set current_schema ...".
PARAMETERS
schema_name
|
Any valid schema name
|
EXAMPLE 1
SQL>connect system@test
Connected to system@test
SQL>x-set schema sys;
Current schema set to SYS
SQL>select count(*) from obj$;
COUNT(*)
----------------------------------------
49651
1 row(s) selected
|