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
- 2 Answers
- 8002 Views
- Fintellix, I also Faced
- E-Mail Answers
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
What is the difference between in and between in sql?
What is data type in database?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What's the difference between a primary key and a clustered index?
What are the types of subqueries?
Does view store data in sql?
Differentiate between sga and pga.
What does desc stand for?
Can we use update in sql function?
What are analytic functions in sql?
How to take user input in pl sql?
What is pragma in pl sql?
What can you do with pl sql?
Explain what is a field in a database and record in a database?
Can we insert delete data in view?
