OraFAQ Forum: SQL & PL/SQL » Sql Statements

Home » SQL & PL/SQL » SQL & PL/SQL » Sql Statements

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql Statements [message #36711]

Thu, 13 December 2001 22:46

Ibrahim
Messages: 16
Registered: October 2001

Junior Member

Hi all,

How I can call a text file that contains a lot of sql statments such as create table, instert into etc.
from SQL prompt. The text file name is MyTableData.txt

I want to run the entire statements in the text file, by a single command in SQL prompt. Is that possible?

If so, Pls give me more details about the correct punctuations that separating each statements in the text file.

I am using Oracle8 Enterprise edition.

your help would be appreciated.

thanks and regards,

Ibrahim

----------------------------------------------------------------------

Report message to a moderator

Re: Sql Statements [message #36722 is a reply to message #36711]

Fri, 14 December 2001 06:20

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

Example:
txt file contents

create table x (n number);
create table y (s varchar2(10));

save above statements in file , lets say samp.txt

run samp.txt at sqlplus using syntax below

SQL > @samp.txt

(give total path when you save in different directory than sqlplus default directory)

SQL > @c:samp_dirsamp.txt

----------------------------------------------------------------------

Report message to a moderator

Re: Sql Statements [message #36734 is a reply to message #36722]

Fri, 14 December 2001 20:00

Ibrahim
Messages: 16
Registered: October 2001

Junior Member

Thank you Mr.Suresh. It is working.
Thank you

Ibrahim

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Updating a LONG Column
Next Topic:	Get child tables.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 20:20:08 CDT 2025