Answer Posted / avi007
full outer join -
select * from table1,table2 where
table1.columnname(+)=table2.colunmname;
union
select * from table1,table2 where
table1.columnname =table2.colunmname(+);
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of using pl/sql?
What is the use of sql trace?
Is truncate ddl or dml?
What is secondary key?
What is the difference between count 1 and count (*) in a sql query?
Why do we need cursor in pl sql?
Is sql a programming?
What is optimistic concurrency control? : Transact sql
What is a stored procedure in sql with example?
What is trigger and types?
Is inner join same as self join?
What is the most common sql injection tool?
Which is faster union or join?
Define concurrency control. : Transact sql
What are the advantages of indexing?