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 to run sql*plus commands in sql developer?
what is bcp? When is it used?
What is the file extension for sql database?
How to run sql statements with oracle sql developer?
What is sql performance tuning?
What is sql resultset?
How do temporal tables work?
What are tuples in sql?
What is the difference between inner join and outer join?
How to raise user-defined exception with custom sqlerrm ?
what are date and time data types in mysql? : Sql dba
Is sql low level language?
What is sorting in sql?
what are dynamic queries in t-sql? : Transact sql
Does sql*plus have a pl/sql engine?