create table question
From: <badstreetboy_at_my-dejanews.com>
Date: 1998/10/02
Message-ID: <6v3lap$mur$1_at_nnrp1.dejanews.com>#1/1
Date: 1998/10/02
Message-ID: <6v3lap$mur$1_at_nnrp1.dejanews.com>#1/1
[Quoted] I want to create a table that has 2 fields:
1st field: f1, integer, default 0
2nd field: f2, integer, copy exact rows from other table
so that I will have a table like:
0, aaa
0, bbb
...
I used to do this in Ingres:
create table table_name as select int4(0) as f1, f2 from other_table;
How to do this in Oracle?
Thanks!!
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 02 1998 - 00:00:00 CEST