Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie -very newbie- question

Re: Newbie -very newbie- question

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 18 Sep 1999 19:59:33 +0200
Message-ID: <937677641.12453.0.pluto.d4ee154e@news.demon.nl>


save the commands in a file and either
sqlplus -s (remark this suppresses the logon banner) scott/tiger_at_yourdb @newbie
or
sqlplus scott/tiger_at_yourdb
(sqlprompt) start (or @) newbie (assuming the extension is .sql)

Hth,

--
Sybrand Bakker, Oracle DBA
itsreal <itsreal_at_test.com> wrote in message news:7s08t3$dfo_at_dfw-ixnews19.ix.netcom.com...
>
> >sqlplus scott/tiger@<your database>
> >(sql prompt) create or replace procedure newbie
> > is
> > begin
> > dbms_output.put_line('Hello world');
> > end;
> > /
> > set serveroutput on size 20000
> > exec newbie
> > rem or
> > begin
> > newbie;
> > end;
> > /
>
> Thanks a lot Sybrand.
> But how do I make it run if the source is in a file and I don't want to
type
> it again inside sqlplus ?
> Thanks again.
> andres
>
>
Received on Sat Sep 18 1999 - 12:59:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US