when loggined as SYSTEM,how to display all the users of database using sql query?
Answer Posted / pradeep
select * from all_users;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to define an anonymous procedure with variables?
How to execute the package in oracle?
What is the implicit cursor in oracle?
Explain mutating triggers.
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Explain the difference between sql and oracle?
What is raw datatype?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain the use of tables option in exp command.
How to add another datafile to a tablespace?
What is the recommended interval at which to run statspack snapshots, and why?
What is a nvl function? How can it be used?
What are the differences between primary key and unique key?
How to use an explicit cursor without open statements?
How to run queries on external tables?