How to find out what privileges a user currently has in oracle?
Answer Posted / abc
Select * from user_sys_privs;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is the difference between primary key and unique key and foreign key in oracle?
What are the different types of synonyms?
Can a parameter be passed to a cursor?
How to login to the server without an instance?
How to get a create statement for an existing table?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Why do we use coalesce function in oracle?
Explain the dml?
what are actual and formal parameters?
What is define in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Why do we use bulk collect in oracle?
What are a collation and state the different types of collation sensitivity?