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 procedure and function?
What is prepared statement in sql?
What are the types of operators available in sql?
What is trigger with example?
How many types of cursors supported in pl/sql?
What is the use of & in pl sql?
how to create a new view in mysql? : Sql dba
Does truncate free space?
What is meant by cursor in sql?
Explain scalar functions in sql?
Describe different types of general function used in sql?
What are the different types of constraints?
How does one use sql*loader to load images, sound clips and documents? : aql loader
how to convert dates to character strings? : Sql dba
How run sql*plus commands that are stored in a local file?