How to get the recordcount?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Fri, 21 Aug 1998 09:09:58 GMT
Message-ID: <35e23962.33747584@news.twsc.pouchen.com.tw>

Hello,
If I declare a cursor,
DECLARE

      CURSOR C1 IS
               SELECT * FROM EMP WHERE ......;
BEGIN
      OPEN C1;
         :::::::::

END;
How could I know C1's recordcount?

And how to use SQL%NOTFOUND?
Is it like this?
BEGIN

      SELECT * FROM EMP WHERE....
      IF SQL%NOTFOUND THEN
          INSERT INTO EMP........
      ELSE 
          UPDATE EMP......
     END IF;

END; Please CC to: violin.hsiao_at_mail.pouchen.com.tw,Thank you so much :) Received on Fri Aug 21 1998 - 04:09:58 CDT