Re: QUERY PROBLEM?

Try this

J. Yen wrote:
>
> I used the below SQL statement, but only last record selected.
> DECLARE
> CURSOR C IS
> SELECT A.SEQNO
> ,A.NAME
> FROM NAME A
> WHERE A.DEPT = 'ACCT';
>
> BEGIN
> OPEN C;
> LOOP
> FETCH C INTO
> :SEQNO, :NAME;
insert_record ;

> EXIT WHEN C%NOTFOUND;
> END LOOP;
> CLOSE C;
>
> END;
>
> Does anyone know the problem in this SQL statement? Thank you!

MfG
Ingo Zawada Received on Mon Jun 22 1998 - 14:05:57 CEST