OraFAQ Forum: Client Tools » sql worksheet script running

Home » Other » Client Tools » sql worksheet script running (11G Linux)

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

sql worksheet script running [message #422145]

Mon, 14 September 2009 13:31

rkl1
Messages: 97
Registered: June 2005

Member

Dear All,

Is there a way to run multiple sql statements run one after another like script using the sql worksheet inside DBCONSOLE(datamovement-sql worksheet).

Also if you have a script in a file, do you have to cut and paste to run it.

Thanks.

Report message to a moderator

Re: sql worksheet script running [message #422423 is a reply to message #422145]

Wed, 16 September 2009 05:47

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

You can put multiple SQL statements into a single file, and run it from SQL*Plus with the @<filename> command.

Report message to a moderator

Previous Topic:	DataLoader versus Custom Interface
Next Topic:	session times out every 10 minutes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 01:19:15 CDT 2024