Ans: showing error (ORA-00904: "A"."A": invalid identif

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

Question Posted / sudarshanbehera07@gmail.com

2 Answers
8593 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

Please Help Members By Posting Answers For Below Questions

What is procedure and function?

944

What is prepared statement in sql?

1015

What are the types of operators available in sql?

1022

What is trigger with example?

1038

How many types of cursors supported in pl/sql?

1122

What is the use of & in pl sql?

1004

how to create a new view in mysql? : Sql dba

907

Does truncate free space?

957

What is meant by cursor in sql?

956

Explain scalar functions in sql?

1032

Describe different types of general function used in sql?

994

What are the different types of constraints?

1102

How does one use sql*loader to load images, sound clips and documents? : aql loader

1138

how to convert dates to character strings? : Sql dba

1104

How run sql*plus commands that are stored in a local file?

1005