Re: add

"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 etc
More details in the sql reference manual.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri May 04 2001 - 03:40:02 CDT