Home » SQL & PL/SQL » SQL & PL/SQL » SQL PLUS- running SQL
SQL PLUS- running SQL [message #21841] Wed, 04 September 2002 02:36 Go to next message
Michael
Messages: 61
Registered: October 1999
Member
I created a large script in notepad.
When I attempt to paste it into sql plus it only pastes part of it - it's like there's a limit on what you can paste in. CAN I GET AROUND THIS?

when I attempt to run the script by opening a file using start it seems to run some of it and then stop: -
the output shown at the end.
HOW CAN YOU RUN A LONG SCRIPT IN SQL PLUS????
"Table dropped.

Table created.

Sequence dropped.

Sequence created.

Table dropped.

Table created.

Sequence dropped.

Sequence created.

527 "

Report message to a moderator

Re: SQL PLUS- running SQL [message #21842 is a reply to message #21841] Wed, 04 September 2002 03:04 Go to previous messageGo to next message
Keith
Messages: 88
Registered: March 2000
Member
Use the @ command within SQL*Plus. e.g.

krjf@9i> @c:tempmyverylargefile.sql

Report message to a moderator

Re: SQL PLUS- running SQL [message #21845 is a reply to message #21841] Wed, 04 September 2002 03:37 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
You can save the file as a sql file and then on the sql prompt run the script by typing:

@ filepathfilename

Ex:

@ c:tempMyScript.sql

Report message to a moderator

Previous Topic: stored procedure
Next Topic: ora-4020 deadlock detected while trying to lock object:
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:45:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.