Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie -very newbie- question
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
![]() |
![]() |