1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( sele..

Answer / kuldeep123

it will gives result as 1 and null

Is This Answer Correct ?    3 Yes 1 No

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( sele..

Answer / sudarshanbehera07@gmail.com

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

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What does pragma mean?

0 Answers  

how can i read write files from pl/sql

3 Answers  

What are basic techniques of indexing?

0 Answers  

How many types of relationship are there?

0 Answers  

Is big data nosql?

0 Answers  




Which command is used to delete a package?

0 Answers  

Do we need commit after truncate?

0 Answers  

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

What is difference between sql and oracle?

0 Answers  

how many values can the set function of mysql take? : Sql dba

0 Answers  

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

For more SQL PLSQL Interview Questions Click Here
Categories