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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to use scripts with sql-Plus 3.3 ??

Re: How to use scripts with sql-Plus 3.3 ??

From: Wicus Maas <wicus_at_bsw.co.za>
Date: Mon, 5 Oct 1998 13:45:00 +0200
Message-ID: <907587232.944148@ns1.bsw.co.za>


I hope this answers your question:

\ORAWIN\BIN\PLUS33.EXE C:\ORAWIN\BIN username/password_at_instance @path.sql

where 'instance' is the database you want to connect to and
path.sql is the sql file you want to execute.

Thanx

Wicus Maas

ziv103_at_my-dejanews.com wrote in message <6ug5cq$tcc$1_at_nnrp1.dejanews.com>...
>try to remove the semicolon and
>write a / in a seperate line after
>each SQL statement
>
>HTH
>In article <36062675.524634764_at_news.newsguy.com>,
> Pablo.picasso_at_cyberdude.com (Pablo Picasso) wrote:
>> Hi,
>>
>> i have to extracted some SQL-Statements to build tables and procedures
>> und even users.
>>
>> If try to open the script file with sql-plus 3.3 i works fine. But if
>> execute it with the run command,
>> then there is an error at first semikolon.
>>
>> Have to do soething special to use scripts ??
>>
>> P.S. If i execute one statement after the other, it works..
>>
>> Does anyone have a suggestion ??
>>
>> Thanks in advance..
>>
>>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Oct 05 1998 - 06:45:00 CDT

Original text of this message

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