Re: PL/SQL script help (Forest & Trees)

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Tue, 20 Oct 1998 15:57:12 +0100
Message-ID: <70i8bk$2he$1@schbbs.mot.com>

Ok try this then.

DECLARE
     MyCount NUMBER;
BEGIN
   SELECT COUNT(*)

     INTO MyCOunt
       FROM TableOfChoice;

END; This will simply retrieve a count of records in a table into a local variable. Of course, it doesn;t do anything with it aftrewards. I guess that part's over to you.

--
Alan D. Mills

knez wrote in message <708355$cih_at_sjx-ixn9.ix.netcom.com>...
>Can someone give me a very small PL/SQL Script. I did receive one from Alan
>Mills ( Thanks a million Alan)
>BEGIN
> NULL;
>END;
>/
>It worked with SQL*Plus but I got a null error when going through Forest &
>Trees (Platinum). I would like to try another short script that won't pull
>back a null value. I would like to try a script that will do a row count
>using PL/SQL. Any help would be appreciated. I'm waiting on a PL/SQL
>reference book to be mailed.
>
Received on Tue Oct 20 1998 - 09:57:12 CDT