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: What does this mean?

Re: What does this mean?

From: Tanya Injac <tanyainjac_at_unn.unisys.com>
Date: 24 May 1998 23:57:00 GMT
Message-ID: <01bd876f$aa4af280$6762df81@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 Sun May 24 1998 - 18:57:00 CDT

Original text of this message

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