Sign Up Login


  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 are the types of triggers in sql?

0 Answers  

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

What is embedded sql with example?

0 Answers  

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

what is d diff between grant,commit,rollback n savepoint

1 Answers  




Does truncate require commit?

0 Answers  

What packages are available to pl/sql developers?

0 Answers  

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

write the Sql query for creating database backup?

7 Answers   TCS,

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories