Members   Search   Help    Register    Login   Home
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: 156
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 Go to previous messageGo to next message
BlackSwan
Messages: 3366
Registered: January 2009
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 Go to previous messageGo to next message
Frank
Messages: 7317
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 Go to previous messageGo to next message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 Go to previous messageGo to next message
Its_me_ved
Messages: 127
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 message
nastyjillu
Messages: 156
Registered: February 2009
Senior Member
thanks Its_me_ved, it works for me.

thanks to all
Report message to a moderator
Previous Topic:variable vs set serveroutput on
Next Topic:What's the camera icon on the pl/sql developer tool bar?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 14:01:11 CST 2009

Total time taken to generate the page: 0.04484 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.