Answer Posted / Nibha Kumari
SQL Join Syntax:nLEFT JOIN: SELECT table1.column, table2.column FROM table1 LEFT JOIN table2 ON table1.common_column = table2.common_columnnRIGHT JOIN: SELECT table1.column, table2.column FROM table1 RIGHT JOIN table2 ON table1.common_column = table2.common_columnnINNER JOIN: SELECT * FROM table1 INNER JOIN table2 ON table1.common_column = table2.common_columnnnORACLE Join Syntax:nLEFT OUTER JOIN: SELECT table1.*, table2.* FROM table1, table2 WHERE (table1.common_column = table2.common_column) AND (table2.column IS NULL)nRIGHT OUTER JOIN: SELECT table1.*, table2.* FROM table1, table2 WHERE (table1.common_column = table2.common_column) AND (table1.column IS NULL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
How to use values from other tables in update statements using oracle?
How to start an oracle instance?
