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
What is the difference between primary key and unique key and foreign key in oracle?
Why does oracle 9i treat an empty string as null?
How to view the tablespaces in the current database?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain an extent?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is a table index in oracle?
How to fetch the row which has the max value for a column?
What is the oracle implicit cursor?
Explain do view contain data?
Differentiate between pre-select and pre-query?
What is the difference between post-database commit and post-form commit?
What are the general rules on data consistency?
How to select some columns from a table in oracle?
What are data pump export and import modes?