Tuesday, October 21, 2008

Oracle User and Schema

Who am I?
SQL> Select Instance_Name From v$Instance;

INSTANCE_NAME
----------------
orcl10

SQL> Select Name From v$Database;

NAME
---------
ORCL10

SQL> Select User From Dual;

USER
------------------------------
SCOTT

No comments:

Post a Comment