when loggined as SYSTEM,how to display all the users of database using sql query?

Answers were Sorted based on User's Feedback



when loggined as SYSTEM,how to display all the users of database using sql query?..

Answer / phan wai keong

select * from dba_users;

Is This Answer Correct ?    6 Yes 0 No

when loggined as SYSTEM,how to display all the users of database using sql query?..

Answer / pradeep

select * from all_users;

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle General Interview Questions

Can we commit inside a function in oracle?

0 Answers  


create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,


Give syntax for SQL and ORACLE joins.

0 Answers   TCS,


What is an oracle user account?

0 Answers  


if i am using dml statement in function. then i am writing select statement what was the output

2 Answers   MasterCard,


What is oracle rownum?

0 Answers  


How a database is related to tablespaces?

0 Answers  


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

0 Answers  


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

0 Answers  


What is the best way to do multi-row insert in oracle?

0 Answers  


What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

1 Answers  


What is meant by redo log buffer ?

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)