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: Wei Weng <wweng_at_attila.stevens-tech.edu>
Date: 24 May 1998 17:38:15 GMT
Message-ID: <6k9lu7$6fv$1@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 - 12:38:15 CDT

Original text of this message

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