How to get a list of all user accounts in the database?
No Answer is Posted For this Question
Be the First to Post Answer
What is merge in oracle?
What is the difference between postgresql and oracle?
what are bitmap indexes? How does they work?
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?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
What happens if you use a wrong connect identifier?
How to retrieve data from an explicit cursor?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the purpose of a cluster?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
what are the advantages of running a database in NO archive log mode?