Re: PL/SQL Loop help needed

I suggest posting this to the Qust RevealNet pipelines in the pl/sql pipeline, you will probably get a quicker responce.

http://pipetalk.quest-pipelines.com/~plsql

Mike

c.golding_at_mailbox.uq.edu.au (Crystal) wrote in message news:<7dd0d93b.0208152223.1c0b5080_at_posting.google.com>...
> This is my first attempt at PL/SQL.
>
> 1) I have a record, PSRECFIELD from which I can extract a list of all
> records in the Oracle 8i db that contain the field EMPLID. This can
> be gained by the SQL Select RECNAME from PSRECFIELD where FIELDNAME =
> 'EMPLID';
>
> 2) I need to then find which of those records contains an EMPLID of a
> specific value. For example, if selecting from a single table the SQL
> is Select EMPLID from PSTAB1 where EMPLID = '1234';
>
> 3) How do I set up the PL/SQL loop so that I can loop through all
> records returned in 1) to find and report only those records that have
> an EMPLID value of '1234' as in 2)??????
Received on Sun Aug 18 2002 - 19:24:49 CEST