PL/SQL cursor

I have a cursor defined below:

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 CST