Answer Posted / kumar
Types of joins are :
Equi-Join
Non-Equi-Join
Right Outer Join
Left Outer Join
Full Outer Join
Self Join
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to rename an existing table?
candidate key is subset of super key but not vice-verse explain
What is a connect identifier?
Explain oracle instance.
How to create a single index for multiple columns?
Can select statements be used on views in oracle?
How to view all columns in an existing table?
How to use attributes of the implicit cursor in oracle?
Explain table?
what is the dual table in oracle?
What is an oracle user role?
What are the most common interview questions on ETL Testing for experience?
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
Why oracle is used?
What is a trigger and what are its types in oracle?