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
What is a cursor in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to run create database statement again?
How do I recompile a procedure in oracle?
What is the meaning of recursive hints in oracle?
How to use null as conditions in oracle?
Point the difference between translate and replace?
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
What is analyze command used for?
Explain the characteristics of oracle dba?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is a nested table and how is it different from a normal table?
How can we find out the duplicate values in an oracle table?
What is background process in Oracle?
what is port in oracle? how is it related to database application.