create table question

From: <badstreetboy_at_my-dejanews.com>
Date: 1998/10/02
Message-ID: <6v3lap$mur$1@nnrp1.dejanews.com>#1/1

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 CDT