Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 98060 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / arpit gautam
Joins condition could be either of the one.
1.SQL SERVER
2.ORACLE SERVER
1.SQL SERVER
SQL SERVER having five joins.
a)CROSS JOIN
b)NATURAL JOIN
c)USING CLAUSE
d)OUTER JOIN
e)ARBITRARY JOIN
2.ORACLE SERVER
a)EQUI JOIN
b)NON EQUI JOIN
c)OUTER JOIN
d)SELF JOIN
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain the use of rows option in exp command.
what is port in oracle? how is it related to database application.
Explain the features of oracle?
How to rename an existing table?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Explain oracle data types with examples?
What are a collation and state the different types of collation sensitivity?
what is reindexing?
How to create a table in a specific tablespace?
How to loop through a cursor variable?
Explain the use of consistent option in exp command.
How to end the current transaction in oracle?
What are the components of logical database structure in oracle database?
How is it different from a normal table?
When do I need to use a semicolon vs a slash in oracle sql?
