Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: insert a column
HI!
You don't need to add a rowid column there always is one there...
Just query:
select rowid from mytable;
But if you want to add a column it's ALTER TABLE
eg:
ALTER TABLE mytable add mycolumn number(2);
In article <7udfep$dqb$1_at_nnrp1.deja.com>,
nmadson_at_my-deja.com wrote:
> Is it possible to insert a column (specifically a rowid column) into
an
> already populated Oracle table? So far I've had to create a new table
> and load the data into that table; I thought SQL had a MODIFY TABLE
> command that would let you do that, but I don't see such a command in
> the reference books I've got.
>
> Nolan Madson
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 18 1999 - 06:28:33 CDT