Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: add
alter table client add (age number);
Howard J. Rogers wrote:
>
>
>
> "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.
> >
>
> What "gives" is a hell of a lot of leeway when it comes to people not
> knowing the basic (read: VERY basic) Oracle data types. Give you a hint:
> INT ain't one of 'em.
>
> *PLEASE* read a manual. Any manual. I don't really care which one (so
long
> as it isn't the one for DOS 6.2).
>
> And then try "number".
>
> Regards
> HJR
>
>
>
>
>
>
>
>
>
> > 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
> > >
> > >
> >
> >
>
>
-- Posted via CNET Help.com http://www.help.com/Received on Fri May 04 2001 - 11:30:08 CDT