Re: add

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 4 May 2001 13:24:27 +0200
Message-ID: <tf547b3h69bi49@beta-news.demon.nl>

If you respond in this fashion, you are just asking for a reply with a FLA. It is *NUMBER*

RTFM and don't bother this group anymore before you have done this. Please don't ask syntax questions!

Regards,

Sybrand Bakker, Oracle DBA

"las @online.no>" <laasunde<remove> wrote in message news:b_vI6.3846$Ty6.71298_at_news1.oke.nextra.no...
> Thanks for your reply, I did "alter table client add age(int); and got
> invalid datatype error. What gives.
>
> las
>
>
> "Pavel Khakhaev" <pvh65_at_mail.ru> skrev i melding
> news:EC0DB93033E9D411B47100A0C945C0793A6EB4_at_exchange.stinol.int...
> >
> > "las" <laasunde_at_online.no> wrote in message
> > news:GSsI6.3779$Ty6.70500_at_news1.oke.nextra.no...
> > > I've got a table called "client" with the following fields :
> > > name,address,city,country
> > > How can I add a field, say "age" to this table with out deleting and
> > > re-creating the table ?
> > >
> > > Thanks
> > >
> > > las
> > >
> > alter table CLIENT add AGE(datatype);
> > Pavel
> >
> >
>
>
Received on Fri May 04 2001 - 06:24:27 CDT