2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A
Full outer join ( select 1 B from dual Union select 2 B from dual)B
On A.A=B.B
Post New Answer View All Answers
Can a view be mutating? If yes, then how?
What is the difference between delete and truncate commands?
What do we need to check in database testing?
what are integrity rules?
What are commit, rollback, and savepoint?
What is the use of count (*) in sql?
Why we use cross join?
Is sql microsoft?
how mysql optimizes distinct? : Sql dba
What is the difference between an inner join and an outer join?
What does rownum mean in sql?
What is a string data type in sql?
What are instead of triggers?
What is sql key?
Which software is used for pl sql programming?