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

Answer Posted / phan wai keong

select * from dba_users;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I get column names from a table in oracle?

752


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1761


In what script is snap$ created? In what script is the scott/tiger schema created?

2454


How to assign a table row to a record variable?

760


What are the different types of synonyms?

816


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1996


What is hash cluster in oracle?

811


How to open a cursor variable?

780


What are the various oracle database objects?

862


What are dml statements in oracle?

795


What is the relationship among database, tablespace and data file?

740


how the indexes are stored in the Oracle Database?

1949


How can we find out the current date and time in oracle?

823


How to delete an existing row from a table in oracle?

840


How to shutdown your 10g xe server from command line?

757