TABLE [message #7149] |
Fri, 23 May 2003 15:24 |
Alma
Messages: 1 Registered: May 2003
|
Junior Member |
|
|
How can I create a new program using a table created previously and inserting data/values from another table?
|
|
|
Re: TABLE [message #7153 is a reply to message #7149] |
Sat, 24 May 2003 01:01 |
jigar
Messages: 74 Registered: July 2002
|
Member |
|
|
create table a (col1 number);
Create table b (col2 number);
Insert into b values (10);
Insert into b values (20);
Insert into b values (30);
Insert into a select col2 from b;
Hope this may solve your problem
|
|
|
|