Hi,
Try the hyphen - character.
i.e.
[Email Address Removed] select 'some long text that will not quite-
> fit onto one line' from dual;
'SOMELONGTEXTTHATWILLNOTQUITEFITONTOONELINE'
----------------------------------------------------
some long text that will not quite fit onto one line
HTH
Mick Holstead
-----Original Message-----
From: Ranganath H M
[mailto:oracledba-ezmlmshield-x88999441.[Email address protected]
Sent: 03 July 2006 08:10
To: LazyDBA Discussion
Subject: SQL>limited to certain length ??
Hi all,
I am unable to type as much as i required in SQL> prompt (version 8.1.5
on Solaris).
Which is the parameter to increase this.
Thanks in advance,.
Rings
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page