new table creation with data from different tables

[raj chopra]

Hi All,

I am using oracle 9i as my database.

I am in need to create a new table(Bill) by copying some of required columns in older 'table A'. this was done and all the existing data was copied from "tableA" to "bill" table.

how ever now anorther column from "tableB" needs to be copied in to my "Bill" table.

i tried to with alter command but was not useful.

kindly let me how to copy all the data of certain column in table to the new table.

[Ashwin Sridhar]

Whats the relation between your Bill table and table2. Some more information, would help me understand better.

[raj chopra]

Hi Ashwin,

Thanks for reply.

"tableb" has these columns
org_id,
org_name,
org_ein,

"bill" table has below columns
org_id,
mem_id,
mem_name

all the org_id's in "tableb " are present in "bill"table. now i want to copy the org_name to bill table

Ashwin Sridhar wrote:Whats the relation between your Bill table and table2. Some more information, would help me understand better.

[raj chopra]

HI,

i tried below query


select o.org_name
into bill from tableb o,bill b
where b.org_id = o.org_id


got error as "missing keyword"

[Bill Gorder]

This does not seem to be ORM related so moving this to the JDBC forum for you.

[Wendy L Gibbons]

what you want is an update with subselect statement.

[Wendy L Gibbons]

use the alter command to add the column, then an update to insert the data.

[raj chopra]

Hi Wendy,

Wendy Gibbons wrote:what you want is an update with subselect statement.

thanks for reply the problem was solved. iused the alter command to add the new column and later on used the update query to copy all the needed data.