Home » SQL & PL/SQL » Client Tools » how to paste huge code in SQLPLUS (oracle 10g)
how to paste huge code in SQLPLUS [message #429578] Wed, 04 November 2009 11:52 Go to next message
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
Re: how to paste huge code in SQLPLUS [message #429580 is a reply to message #429578] Wed, 04 November 2009 11:58 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>other question is, how to open a notepad file in sqlplus??


SQL> ! notepad

Re: how to paste huge code in SQLPLUS [message #429581 is a reply to message #429578] Wed, 04 November 2009 12:02 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: how to paste huge code in SQLPLUS [message #429582 is a reply to message #429578] Wed, 04 November 2009 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: how to paste huge code in SQLPLUS [message #429585 is a reply to message #429578] Wed, 04 November 2009 12:13 Go to previous messageGo to next message
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 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
thanks Its_me_ved, it works for me.

thanks to all
Re: how to paste huge code in SQLPLUS [message #634859 is a reply to message #429578] Mon, 16 March 2015 20:51 Go to previous messageGo to next message
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!
Re: how to paste huge code in SQLPLUS [message #634860 is a reply to message #634859] Mon, 16 March 2015 21:02 Go to previous message
BlackSwan
Messages: 25033
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/
Previous Topic: Spool Command
Next Topic: SQL*Plus not executing scripts, goes into an editor mode(!?) instead
Goto Forum:
  


Current Time: Sat Dec 03 08:15:43 CST 2016

Total time taken to generate the page: 0.15449 seconds