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
8645 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

explain the advantages and disadvantages of stored procedure? : Sql dba

991

Can you call pl/sql package functions from within a fast formula?

1021

What is an inner join sql?

1012

What does select top 1 do in sql?

1077

What are the disadvantages of file system?

1240

What is foreign key in sql with example?

912

when MSQL8.0 is in market

2064

What is dbo in sql?

941

What is an ndf file?

974

What are sql queries used for?

1008

What are operators available in sql?

1024

What is function and procedure?

1017

What is using in sql?

1062

What are the types of subqueries?

1048

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1045