Explain joins in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
how to delete all duplicate records from a table using subquery?
What is a public synonym?
various types of hints and their usage
How is it different from a normal table?
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
How to open and close an explicit cursor in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
difference between truncate and delete ,drop?
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
Explain an index?
What is system tablespace?
What are the composite date types in oracle?