Answer Posted / lakshminrayana reddy
5 types
1) Equi join
2) cartesian join
3) non-equi join
4)outer join(+)
i)left outer join
ii) right outer join
5)self join
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Is there a way to automate sql execution from the command-line, batch job or shell script?
How to move files from one directory to another in pl sql?
Why do we use view in sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Is sql a scripting language?
What is join view in sql?
Can we create clustered index without primary key?
What are the sql commands?
What are local and global variables and their differences?
how to select first 5 records from a table? : Sql dba
Why use truncate instead of delete?
What is a primary key sql?
what are all the different normalizations? : Sql dba
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is auto increment in sql?