Re: how to put multiple select in a run.sql file?
From: David Johnson <dave_at_db-wiz.net>
Date: Wed, 4 Sep 2002 22:52:53 -0400
Message-ID: <YAzd9.55553$0u4.1032797_at_news4.srv.hcvlny.cv.net>
Date: Wed, 4 Sep 2002 22:52:53 -0400
Message-ID: <YAzd9.55553$0u4.1032797_at_news4.srv.hcvlny.cv.net>
>> sqlplus user/user_at_dbRacedat < run.sql
try
sqlplus user/user_at_dbRacedat @run.sql
either the ; or / will work, but / has to be the first char on the line if
it is used.
i.e.
select * from dual;
or
select * from dual
/
also
select * from dual;
/
will actually run the query twice!!
the / is required to run plsql anonymous blocks.
except when using the exec directive.
i.e.
declare
x number(2);
begin
x := 0;
x:=x+1;
dbms_output.put_line(x);
end;
/
exec myprocedure( 'one' ); Received on Thu Sep 05 2002 - 04:52:53 CEST