various types of joins

Answer Posted / shankar

1. Equi Join
2. Non-Equi join
3. Outer Join
4. Self Join

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain index?

745


What privilege is needed for a user to delete rows from tables in another schema?

562


How to create an oracle database?

582


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1611


How to assign a table row to a record variable?

582






How to insert a record into a table?

640


What is control file used for?

602


What is the quickest way to fetch the data from a table?

568


What is key preserved table?

561


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)

1807


Why does for update in oracle 8 cause an ora-01002 error?

543


How to start a specific oracle instance?

582


What is the purpose of tables, private synonyms and public synonyms in Oracle?

587


When system tablespace is created?

605


How to display row numbers with the records?

587