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


Please Help Members By Posting Answers For Below Questions

How to run sql*plus commands in sql developer?

589


what is bcp? When is it used?

578


What is the file extension for sql database?

515


How to run sql statements with oracle sql developer?

619


What is sql performance tuning?

492






What is sql resultset?

527


How do temporal tables work?

514


What are tuples in sql?

561


What is the difference between inner join and outer join?

528


How to raise user-defined exception with custom sqlerrm ?

678


what are date and time data types in mysql? : Sql dba

500


Is sql low level language?

574


What is sorting in sql?

503


what are dynamic queries in t-sql? : Transact sql

557


Does sql*plus have a pl/sql engine?

569