PL/SQL cursor

[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