Ascending Cursor for multiple index

yourchoice_amit · New User Joined: 01 Sep 2005 Posts: 5 Location: Mysore

Hi,

I need to code a ascending cursor for a table with the following index,

DATE
TYPE
PRICE
CONTRA (NULL exist)
ADD_TIMESTAMP

Can anybody help me in writing a cursor to fetch the rows in an ascending pattern. My ORDER_BY preference would be in the order mentioned above.

Thanks in Advance.

dick scherrer · Posted: Mon Apr 06, 2009 3:22 am

Hello,

Where is the difficulty? Declare the cursor as

select from..
where. . .
order by . . .

If you are having problems (syntax or undesired sql return codes), post your code and the error(s) and someone will be able to clarify.

yourchoice_amit · New User Joined: 01 Sep 2005 Posts: 5 Location: Mysore

how do i give a WHERE clause for CONTRA which has NULL values and VALID Alpha numeric in it.
???

ashimer · Posted: Mon Apr 06, 2009 9:55 pm

Amit .. are you concerned about your order by or where clause ...
post the current SQL and the problem you are facing with an example ...
it would be easy for us to help ...