ALTERNATIVE TO CASE IN ORACLE-CURSORS

[sreenathkm]

Hi Can any one suggest me a alternative to CASE, as I relaised that I cant use CASE in a Cursor..

Any immediate help will be highly appreciated.

Thanks in advance

 

[sahernandez]

I guess you are try to use a Case because you need to use <= or >= or < or >.

Let me know if that is the reason!!.
Alexander

 

[sreenathkm]

I am trying to make some conditional selects using CASE where my output also have to be changing accordingly

Thanks for replying

 

[djbjr]

Create a stage table and the open that as a cursor.

ex.

INSERT INTO STG_TABLE
SELECT a, b, CASE ....END from table_a

DECLARE
CURSOR X IS SELECT * FROM STG_TABLE

hope this helps

 

[sem]

You may try DECODE function. Or use DYNAMIC SQL (ref cursor). It should work.

Regards, Dima