Formatting output on varchar2(256). How to force a certain characters per column 
Author Message
 Formatting output on varchar2(256). How to force a certain characters per column
Hello World.

Can someone show me how to force a fix number of char on a column that
has been defined as varchar2(256)?  Right now, the header/underline
goes for 256 chars (wrapped around my screen several times) even when
my data is less than 20 bytes.

Thks a bunch
Quoc



Wed, 20 Jun 2001 03:00:00 GMT
 Formatting output on varchar2(256). How to force a certain characters per column


(if that email address didn't require changing)

Quote:

>Hello World.

>Can someone show me how to force a fix number of char on a column that
>has been defined as varchar2(256)?  Right now, the header/underline
>goes for 256 chars (wrapped around my screen several times) even when
>my data is less than 20 bytes.

>Thks a bunch
>Quoc

I assume you mean this occurrs in sqlplus?  If so, try this:

  1* select file_name from dba_data_files where rownum = 1
SQL> /

FILE_NAME
-------------------------------------------------------------------
-------------------------------------------------------------------
-------------------------------------------------------------------
-------------------------------------------------------
/d05/dbs/intranet_upload.dbf

SQL> column file_name format a10
     ^^^^^^^^^^^^^^^^^^^^^^^^^^^    this is the important line....
SQL> /

FILE_NAME
----------
/d05/dbs/i
ntranet_up
load.dbf

Thomas Kyte

Oracle Service Industries
Reston, VA   USA

--
http://govt.us.oracle.com/    -- downloadable utilities

----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation

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.



Wed, 20 Jun 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Maximum characters per column - text file output

2. SELECT not returning more than 256 characters for a column

3. varchar column limiting at 256 characters

4. text column truncates after 256 characters

5. SELECT from text column only returns 256 characters

6. Limit of 256 tables per view?

7. workaround for 256 controls per form limit?

8. JDataConnect 256 char limit on callablestatement output parameters

9. 256 character limit in forms

10. DTS 256 character string limitation

11. SQL7 Linked to Access2000 via ODBC (NText Field Sometimes only re turns 256 Characters

12. ODS: srv_setcoldata sends only 256 characters (SQL server 2000)


 
Powered by phpBB® Forum Software