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
Answer Posted / sudarshanbehera07@gmail.com
Ans: showing error (ORA-00904: "A"."A": invalid identifier)
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Why schema is used in sql?
Is sql pronounced sequel or sql?
What are the types of operators available in sql?
What is linq to sql?
Is progress software supports to ( pl/sql )?
Is primary key clustered or nonclustered?
How do you remove duplicates without using distinct in sql?
How do you use join?
What is pl sql quora?
Explain the difference between 'between' & 'and' operators in sql
What is a unique key and primary key and foreign key?
What is clustered index sql?
What is a join?
Why do we use joins?
What is union?