| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: type LONG visible in form, not sqlplus
A copy of this was sent to crd1_at_mindspring.ocm
(if that email address didn't require changing)
On Tue, 23 Jun 1998 01:44:42 GMT, you wrote:
>Greetings...
>
>I'm working with a column of type Long. I'm having to copy and paste
>large amounts of text into these columns through a form. Problem is,
>only about 4 lines of the text is returned in a query. The form
>displays the data fine. Not being able to see all of the text in a
>query is not going to be acceptable. Can anyone enlighten me?
>
>Thanks...
>Craig Duncan
>
>Solaris 2.51
>Oracle 7.3.3
>Forms 4.5
In sqlplus, to see X bytes of the long, you need to issue:
SQL> set long X
You can put that in your login.sql file so it becomes the default when you login. sqlplus will only show so much of the long and thats controlled by the setting of that variable...
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jun 23 1998 - 05:23:23 CDT
 |
 |