What are joins..how many types of joins are there?

Answer Posted / guruswamy

join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins

Is This Answer Correct ?    15 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor in oracle?

644


Can we convert a date to char in oracle and if so, what would be the syntax?

548


How to run create database statement again?

618


How do I recompile a procedure in oracle?

527


What is the meaning of recursive hints in oracle?

530






How to use null as conditions in oracle?

578


Point the difference between translate and replace?

570


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1844


What is analyze command used for?

574


Explain the characteristics of oracle dba?

636


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1652


What is a nested table and how is it different from a normal table?

573


How can we find out the duplicate values in an oracle table?

604


What is background process in Oracle?

624


what is port in oracle? how is it related to database application.

1438