How to write cursor?

I need to write a cursor and need advice.I'm using PL/SQL Oracle 7 db Here is what my SQL statement looks like at the moment;

SELECT distinct G.VALUE as Email, E.VALUE||' '||F.VALUE as Name, H.VALUE as City, J.VALUE as Address, I.VALUE as Postal_Code FROM SVC_DATA E, SVC_DATA F, SVC_DATA G, SVC_DATA H, SVC_DATA I, SVC_DATA J WHERE E.ATTR_NAME = 'CONTACT_FIRST_NAME' AND

F.ATTR_NAME = 'CONTACT_LAST_NAME' AND
G.ATTR_NAME = 'B_EMAIL' AND
H.ATTR_NAME = 'B_CITY' AND
I.ATTR_NAME = 'B_POSTAL_CODE' AND
J.ATTR_NAME = 'B_ADDR_LINE1' AND
E.ENTITY_ID = F.ENTITY_ID AND
F.ENTITY_ID = G.ENTITY_ID AND
G.ENTITY_ID = H.ENTITY_ID AND
H.ENTITY_ID = I.ENTITY_ID AND
I.ENTITY_ID = J.ENTITY_ID

The problem is that all (6) ATTR_NAME have to be present or the query will not return the record.
I need to write a cursor that will return all records even if they do not have all (6) ATTR_NAME

I'm very new to cursors and would appreciate anyones help.

Thanks in advance!
--
Craig Alexander
Island Tel Advanced Solutions Received on Fri Feb 04 2000 - 14:39:19 CST