PL/SQL cursor
From: Phong Paul Tran <ptran_at_houston.geoquest.slb.com>
Date: 1998/04/01
Message-ID: <35228F1C.6F17CE29_at_houston.geoquest.slb.com>#1/1
Date: 1998/04/01
Message-ID: <35228F1C.6F17CE29_at_houston.geoquest.slb.com>#1/1
[Quoted] I have a cursor defined below:
[Quoted] cursor c(cur_id in varchar2) is select myparent from myfamily where myparent_id = cur_id;
My problem is the select statement for this cursor only works on non-null cur_id values. _id;
How do I create a cursor that will work on both null and not null cur_id?
Thank you much for your help.
Paul Tran
pptran_at_slb.com
Received on Wed Apr 01 1998 - 00:00:00 CEST