Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: copy/paste buffer size in SQL*Plus

Re: copy/paste buffer size in SQL*Plus

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 26 Jun 2004 10:27:19 +0800
Message-ID: <40DCDF07.4C0@yahoo.com>


robert wrote:
>
> i generally edit with Visual SlickEdit, then copy and paste
> [Ctrl-V] into the SQL*Plus window. the code executes immediately,
> which is OK. but now the script has gotten big enough that
> only 2/3 (approx.) gets to the window.
>
> start [file]
>
> does work, but i got used to seeing the Whole Thing. there must
> be a setting for this buffer size someplace, but i've yet to
> find it.
>
> will someone reveal this Deep Secret? (no, i didn't find an
> obvious suspect in the o'reilly book).
>
> thanks,
> robert

I use SQLPlus from the DOS window which means you get the cut/paste facilities within the DOS - to which I've yet to find any limiting problems. You also get to do things like up-arrow to get the previous lines, edit on an exiting line etc

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------
Received on Fri Jun 25 2004 - 21:27:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US