Re: Implementing PL/SQL
From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Tue, 16 Nov 1999 12:14:44 -0000
Message-ID: <eVbY3.9$095.960_at_newreader.ukcore.bt.net>
Date: Tue, 16 Nov 1999 12:14:44 -0000
Message-ID: <eVbY3.9$095.960_at_newreader.ukcore.bt.net>
you can run the simplest PL/SQL statement from the SQL*Plus prompt within
Begin
statement;
End;
then issue a '/' and hit ENTER.
you can also place the code in a file and refer to it with a
_at_/directorypath/filename.extentsion
you can also imbed PL/SQL into the database as procedure/functions or packages
You could try getting hold of the Oracle Press book 'ORACLE 8 PL/SQL Programming' by Urman.
Regards
-- Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England) <KevinALewis_at_HotMail.com> The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Maurice Isler <mauricei_at_mindspring.com> wrote in message news:38310e5c.11618074_at_news.mindspring.com...Received on Tue Nov 16 1999 - 13:14:44 CET
> I'm new to Oracle and SQL and would like to know how to implement
> PL/SQL. If I'm reading my information right I'm supposed to implement
> it from the SQL > prompt. But I don't know whether PL/SQL should be
> written as a text file, will it execute from the prompt, how do I
> compile and save the procedures? any help would be appreciated.