Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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 / sudarshanbehera07@gmail.com

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

Is This Answer Correct ?    1 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 / kuldeep123

it will gives result as 1 and null

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,


Show code of a cursor for loop.

0 Answers  


What are the types of functions in sql?

0 Answers  


how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  


What is the difference between rollback and rollback to statements?

0 Answers  






Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  


What is sql and how does it work?

0 Answers  


There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,


what is a primary key? : Sql dba

0 Answers  


What is the unique index?

0 Answers  


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  


what is innodb? : Sql dba

0 Answers  






Categories