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
Is sql better than excel?
Do foreign keys improve performance?
Write a sql query to convert all character to uppercase after hypen.
How do I view a sql database?
Which is the correct statement about truncate and delete?
What are % type and % rowtype?
how does a local variable is defined using t-sql? : Transact sql
Where can I learn sql for free?
What is an invalid partition table?
Why do we use sql constraints?
Can ddl statements be used in pl/sql?
What is data types in sql?
Define union, minus, union all, intersect ?
What is the difference between rename and alias?
What is dense_rank in sql?