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
How do I partition in sql?
List out the acid properties and explain?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Which join condition can be specified using on clause?
What is the difference between union and union all command?
What is the use of non clustered index?
what is foreign key? : Sql dba
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is the difference between a query and a report?
How can we link a sql database to an existing android app?
What is insert command in sql?
What is the use of pl/sql table?
How you improve the performance of sql*loader? : aql loader
what are the differences among rownum, rank and dense_rank? : Sql dba
How to process query result in pl/sql?