Re: What does this mean?

Alternately, you can do a to_char(pk_siteid) in your select if you are leaving it as a character column. Also, you might need to do a column pk_siteid a20 truncated *OR* do a substring as well [like substr(to_char(pk_siteid),1,20)] to get the first 20 characters. If you want the whole value of 38 characters in a 20 character column, do a column pk_siteid a20 word_wrapped and the entire value will display on two lines.

(Check reference manuals on the above - it's been a while and I might be slightly off on the syntax - memory's fuzzy.) --
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Tanya Injac <tanyainjac_at_unn.unisys.com> wrote in article <01bd876f$aa4af280$6762df81_at_nz6220.nz.unisys.com>...
> Put:
> column pk_siteid format 999999999999999
>
> Those "#"'s show up if you have number column and you try to format it as
> characters.
>
> Regards,
> Tanya
>
> --
> Tanya Injac
> Oracle Developer/DBA
> Unisys NZ Ltd
>
> Wei Weng <wweng_at_attila.stevens-tech.edu> wrote in article
> <6k9lu7$6fv$1_at_apocalypse.dmi.stevens-tech.edu>...
> > Wei Weng <wweng_at_attila.stevens-tech.edu> wrote:
> > > What does the a15 in "column site format a15" do?
> > > I understand it is trying to change the format of the column "site".
> > > But how exactly?
> >
> > > thanks
> >
> > Thanks for all had replied. ^^
> > Here is my script:
> >
> > column pk_siteid format a15
> > column name format a20
> > select pk_siteid, name
> > from site where url like '%buildnet%'
> >
> > and I got something like
> >
> > PK_SITEID NAME
> > ---------- --------------------
> > ########## BuildNET
> >
> > For the description of the table it is
> >
> > Name Null? Type
> > ------------------------------- -------- ----
> > PK_SITEID NUMBER(38)
> > NAME VARCHAR2(250)
> >
> > Where do those "#"'s come from? And how to fix it?
> >
> > thanks
> >
> > wei
> >
> >
>
Received on Tue May 26 1998 - 15:04:06 CDT