Re: What does this mean?

In article <6k9lu7$6fv$1_at_apocalypse.dmi.stevens-tech.edu>,   Wei Weng <wweng_at_attila.stevens-tech.edu> wrote:
>
> 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
>
>

Hi Wei,

I hope you have formatted a number column as a20. To set to default, all you have to do is,

column pk_siteid default

then use select statement. It will give you the correct results.

Hope this works.

Yours,
Saravanan

saro_at_psoux141.sgp.hp.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 25 1998 - 22:12:45 CDT