On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

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