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
what is sql in mysql? : Sql dba
Can function return multiple values in sql?
Does access use sql?
How many types of primary keys are there?
What are sql constraints?
what are the differences between char and nchar? : Sql dba
Is sql port 1433 encrypted?
What is trigger in pl sql with examples?
Which one is better subquery or joins?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Why we use pl sql?
discuss about myisam key cache. : Sql dba
When are we going to use truncate and delete?
Why truncate is used in sql?
Advantages and disadvantages of stored procedure?