What is the difference between Select * from sys.dba_users and Select * from dba_users?
please provide me with the correct answer.
thanks in advance
When you login to database as " sqlplus '/as sysdba', you logged in as sys user.. sys is user/schema, you can access your tables without specifying schema name that is 'sys.' , now suppose you have 2 users in database A & B , now you are connected to database as A user but you want to see objects of B user, for example, you have a table called T1 made by B user, so in order to see table T1 data you need to specify " select * from B.T1; " and if you are logged into database as B user/schema, then select * from T1; will show you data of T1 table....hope I am clear now.
Sign up for STechies
Ask Question From Our Experts