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
How can I get column names from a table in oracle?
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
In what script is snap$ created? In what script is the scott/tiger schema created?
How to assign a table row to a record variable?
What are the different types of synonyms?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is hash cluster in oracle?
How to open a cursor variable?
What are the various oracle database objects?
What are dml statements in oracle?
What is the relationship among database, tablespace and data file?
how the indexes are stored in the Oracle Database?
How can we find out the current date and time in oracle?
How to delete an existing row from a table in oracle?
How to shutdown your 10g xe server from command line?