OraFAQ Forum: Client Tools » how to paste huge code in SQLPLUS

Home » Other » Client Tools » how to paste huge code in SQLPLUS (oracle 10g)

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

how to paste huge code in SQLPLUS [message #429578]

Wed, 04 November 2009 11:52

nastyjillu
Messages: 211
Registered: February 2009

Senior Member

i have over 800 lines of code in my TOAD. if i copy that code from TOAD iam unable to paste the whole code in my sqlplus. i am able to paste only 82 lines.
so i had to paste every 82 lines in sqlplus till i paste whole code .

how can i increase the size so that i can paste whole 800 lines code in sqlplus??

i tried "set linesize" command but it didnt help

other question is, how to open a notepad file in sqlplus??

thanks
jillu

Report message to a moderator

Re: how to paste huge code in SQLPLUS [message #429580 is a reply to message #429578]

Wed, 04 November 2009 11:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>other question is, how to open a notepad file in sqlplus??

SQL> ! notepad

Report message to a moderator

Re: how to paste huge code in SQLPLUS [message #429581 is a reply to message #429578]

Wed, 04 November 2009 12:02

Frank
Messages: 7901
Registered: March 2000

Senior Member

Normally with code that size, you would not paste it into sqlplus, but store it in a file (which can be created/altered outside of sqlplus) which would be run from the sqlplus prompt.

Report message to a moderator

Re: how to paste huge code in SQLPLUS [message #429582 is a reply to message #429578]

Wed, 04 November 2009 12:05

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

how can i increase the size so that i can paste whole 800 lines code in sqlplus??

You can't.

Regards
Michel

Report message to a moderator

Re: how to paste huge code in SQLPLUS [message #429585 is a reply to message #429578]

Wed, 04 November 2009 12:13

Its_me_ved
Messages: 979
Registered: October 2009
Location: India

Senior Member

SQL> ED

Paste the content, save 

SQL>/

[Updated on: Wed, 04 November 2009 12:14]

Report message to a moderator

Re: how to paste huge code in SQLPLUS [message #429619 is a reply to message #429585]

Wed, 04 November 2009 14:48

nastyjillu
Messages: 211
Registered: February 2009

Senior Member

thanks Its_me_ved, it works for me.

thanks to all

Report message to a moderator

Re: how to paste huge code in SQLPLUS [message #634859 is a reply to message #429578]

Mon, 16 March 2015 20:51

samshah1993@gmail.com
Messages: 1
Registered: March 2015
Location: Japan

Junior Member

Use SET lin number of lines you need e.g. SET LIN 1000
Paste the query, make sure you don't have any empty lines, empty line makes the sqlplus execute the query
for e.g.
1.select *
2.FROM TABLE A
3.
4.WHERE ...

Empty Line on 3, will execute the query till Line no 3.
Make sure to remove that!

Report message to a moderator

Re: how to paste huge code in SQLPLUS [message #634860 is a reply to message #634859]

Mon, 16 March 2015 21:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

This thread is only 5+ years old.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Previous Topic:	Spool Command
Next Topic:	SQL*Plus not executing scripts, goes into an editor mode(!?) instead

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 02:29:34 CST 2025