Re: PL\SQL Question

From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1996/04/09
Message-ID: <4keef4$67a_at_zimmer.CSUFresno.EDU>#1/1

Dewey,  

I hate SQL*Plus because it is so hard to work with. I develop all my procedures using Forms4.5, and test them from the form, rather than trying to do it in SQL*Plus.  

But here is an example to help you:

....................................

SQL> variable txt1 varchar2(30);
SQL> declare cntr number(3) := 0;
  2 begin
  3 for I in 1..4 Loop cntr:=cntr+2; End Loop;   4 :txt1 := to_char(cntr);
  5 end;
  6 /

PL/SQL procedure successfully completed.

SQL> print txt1

TXT1

---

8

SQL>

........................................

Steve Cosner
Fresno, California

In article <316A8A52.3C42_at_iup.edu>, Dewey G. Miller <gdcwskc_at_iup.edu> wrote:
>Hello All!
>
>I am quite new to Oracle and especially new to PL\SQL.
>
>I have written my code. I have been trying for 2 days to get it to run
>interactively from SQL*PLUS. I am not having much luck at all. Is there
>a way to run PL\SQL from SQL*PLUS. I would like to be able to type the
>script in one line at a time at the SQL*PLUS prompt....
>
>Ultimately, this script will run in batch. Is there a good way to do
>this from a Korn Shell Script??
>
>
>Please respond to e-mail and newsgroup (if possible to do both...)
>
>Thanks in advance,
>
>Dewey G. "Dwight" Miller
>millerdg_at_corning.com
Received on Tue Apr 09 1996 - 00:00:00 CEST