Re: Adding Columns
From: P.S. <ps_at_netvigator.com>
Date: Thu, 03 Dec 1998 16:17:06 +0800
Message-ID: <36664902.19D6EE2A_at_netvigator.com>
Date: Thu, 03 Dec 1998 16:17:06 +0800
Message-ID: <36664902.19D6EE2A_at_netvigator.com>
Are you talking about table columns? i.e. no. of fields in a table? If it is, then try this.
ALTER TABLE ADD ( 1st_extra_field datatype, 2nd_extra_field datatype,.....);
If you talking about inserting rows into a table, then you could try SQL*Loader to insert your values.
kabco wrote:
> How can I add multiple columns to a new table at one time? I am
> currently adding one column at a time from an existing table. I have 450
> more to go.. (Oracle 8 Personal Edition 8.4)
>
> Can anyone provide the proper syntax/
>
> Thanks,
> Bill "A newbie"
Received on Thu Dec 03 1998 - 09:17:06 CET