schema

hi ,

pls can you let me know what is the view name or table name to query to find out the schema which I am in.

Thanks & Regards,
Ramu

show user if you are in sqlplus

Quote:

---

Originally Posted by ramuv

hi ,

pls can you let me know what is the view name or table name to query to find out the schema which I am in.

Thanks & Regards,
Ramu

---

SQL> show user
USER is "SYS"

hi ramuv

you can use show user command on the
SQL> show user;

or
select user from dual;

It gives the username;