What are joins..how many types of joins are there?
Answer Posted / prabhat shukla
Basically there are three types of join
1.Inner join
2.Outer join
3.self join
and there are two types of join based on condition.
1.equi-join(if we use equal operator while joining tables)
2.Non-equi-join( if we use other than equal operator while
joining tables.(this on is rarely used.)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Java Pool in Oracle?
How remove data files before opening a database?
How to drop a stored procedure in oracle?
Explain the blob datatype?
What is an external table?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How can you merge two tables in oracle?
What is merge statement used for?
Where are the settings stored for each instance in oracle?
How do I connect to oracle database?
How to do clean up if create database failed?
How data locks are respected in oracle?
How to count duplicated values in a column in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
what is the scripts in data base?