What are joins..how many types of joins are there?
Answer Posted / tauqueer
Joins means we can join two or more then two table in
single query.
there are 3 types of join..
1. INNER JOIN.
2. OUTER JOIN.
1.Left outer join.
2.right outer join.
3.full outer join.
3. CROSS JOIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
what is reindexing?
please explain.. DB architecture ...
What is background process in Oracle?
How to create a new view in oracle?
How to create a new table by selecting rows from another table?
How to view existing locks on the database?
Explain the use of rows option in exp command.
How to generate query output in html format?
does the query needs a hint to access a materialized view?
What is SQL access advisor in Oracle?
How to bring a tablespace offline?
How does the on-delete-cascade statement work?
What is backup in Oracle?
Explain self joins in oracle?