Home » SQL & PL/SQL » SQL & PL/SQL » TABLE
TABLE [message #7149] Fri, 23 May 2003 15:24 Go to next message
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 Go to previous messageGo to next message
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
Re: TABLE [message #7184 is a reply to message #7149] Tue, 27 May 2003 04:41 Go to previous message
Martin Chadderton
Messages: 35
Registered: May 2003
Member
There's also the CREATE TABLE .. AS SELECT ..
syntax.

Regards
Previous Topic: Can the update of a table be restricted to a particular package only
Next Topic: easy problem
Goto Forum:
  


Current Time: Fri Apr 26 13:36:55 CDT 2024