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
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 |
Answer / eswar reddy
declare one cursor ,PL/SQL TABLE
IN DBMS MENTIONED PRIOR,LAST,FIRST
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What is a Shared SQL pool ?
How will you identify oracle database software release?
if you ctreate table identity
What is a public synonym?
Explain an integrity constrains?
What are advantages of dateset in datastage?
How to use select statement to count the number of rows in oracle?
Explain about functional dependency and its relation with table design?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
Why does for update in oracle 8 cause an ora-01002 error?
How to convert characters to numbers in oracle?