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

Which one is faster ienumerable or iqueryable?

0 Answers  

What is bulk collections?

2 Answers  

How to copy a table in another table with datas?

9 Answers  

How do I tune a sql query?

0 Answers  

What is sql architecture?

0 Answers  




differentiate between float and double. : Sql dba

0 Answers  

How do I make sql search faster?

0 Answers  

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

0 Answers  

What does a pl/sql package consist of?

0 Answers  

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories