1,查看数据库实例名
SELECT NAME FROM V$DATABASE;
2,查看用户名
select username from dba_users;
3,查看当前schema
select SYS_CONTEXT('USERENV','CURRENT_SCHEMA') CURRENT_SCHEMA from dual;
1,查看数据库实例名
SELECT NAME FROM V$DATABASE;
2,查看用户名
select username from dba_users;
3,查看当前schema
select SYS_CONTEXT('USERENV','CURRENT_SCHEMA') CURRENT_SCHEMA from dual;