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>


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...

> 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.
Received on Tue Nov 16 1999 - 13:14:44 CET

Original text of this message