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
Answers were Sorted based on User's Feedback
Answer / sudarshanbehera07@gmail.com
Ans: showing error (ORA-00904: "A"."A": invalid identifier)
Is This Answer Correct ? | 3 Yes | 4 No |
Can we use joins in subquery?
Can a trigger call a stored procedure?
What is primary key and foreign key?
What is dbo in sql?
Are subqueries faster than joins?
How to fetch records from a partitioned table?
Can we use insert statement in function?
What are types of exception?
What is before trigger?
tell us something about heap tables. : Sql dba
What do you mean by field in sql?
How do I create a sql script?