I have a table emp. There is only one column in the table.
In that , there are only three rows in that column.
The value in the first row is 'A' and the value in the
second row is 'B' and the third row is 'C'. Now, my question
is ,

How will you write a select query to display the output as
B
C
A

Note: order by cannot be used coz it gives us output as CBA.
But the output should be BCA.

Answers were Sorted based on User's Feedback



I have a table emp. There is only one column in the table. In that , there are only three rows in t..

Answer / garv

SELECT DECODE (EEE,'A','B','B','C','A') EEE
FROM EMP

--EEE IS COLUMN NAME OF TABLE EMP

Is This Answer Correct ?    9 Yes 3 No

I have a table emp. There is only one column in the table. In that , there are only three rows in t..

Answer / eswar reddy

declare one cursor ,PL/SQL TABLE
IN DBMS MENTIONED PRIOR,LAST,FIRST

Is This Answer Correct ?    0 Yes 0 No

I have a table emp. There is only one column in the table. In that , there are only three rows in t..

Answer / ajitnayak

declare
type samp_type is table of VARCHAR2(20)
index by binary_integer;

table_type samp_type;

cursor c1 is
select Colum-Name from Table_name;

begin
open c1;

fetch c1 bulk collect into table_type;

close c1;

for i in reverse 1..4 loop
dbms_output.put_line(table_type(i));
end loop;
end;

Is This Answer Correct ?    0 Yes 0 No

I have a table emp. There is only one column in the table. In that , there are only three rows in t..

Answer / shriram

Garv : Thats right :) Thank you for your answer :)

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Oracle General Interview Questions

What is the difference between sharding and replication?

0 Answers  


How to select the name of employee who is getting maximum sal with out using subquery

15 Answers  


where do i find oracle interview questions.

1 Answers  


Where are the settings stored for each instance in oracle?

0 Answers  


I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  






How to execute a stored program unit?

0 Answers  


In which language oracle has been developed?

0 Answers  


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

0 Answers   Intelligroup,


What are various constraints used in SQL?

1 Answers   Polaris,


How do I learn what codesets are available in oracle?

0 Answers  


How to use attributes of the implicit cursor in oracle?

0 Answers  


what is the difference between no rows returned and null returned?

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)