Re: Full PL/SQL Programs

From: <rzx2122_at_mcvax2.d48.lilly.com>
Date: 1995/03/30
Message-ID: <1995Mar30.113424.1_at_mcvax2.d48.lilly.com>#1/1

/*

Simple SQL*Plus PL/SQL example
Much easier to read and understand when code is properly indented.

*/
variable one number;
variable two varchar2(20);
begin
  declare
    procedure xyz is

      begin
        :one := 1;
      end xyz;

  begin
    :two := '2';
    xyz;
  end;
end;
/

print one
print two

Tom Harleman
Paradigm Consulting, Inc.
Committee member - Indiana Oracle Users Group

Member - Midwest Oracle Users Group
Member - International Oracle Users Group - Americas
Member - Oracle Case Special Interest Group
Member - Oracle Business Alliance Program
Member - Independent Oracle Consultants Alliance

Email: 72072.2122_at_compuserve.com
"Headhunters - PLEASE DON'T CALL ME!" Received on Thu Mar 30 1995 - 00:00:00 CEST