-
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
-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|