Does Oracle Allow Size Casting During Create Table as (select....)?

When creating a table from a select statement, we need to assign a name to any calculated fields. The question is, can we assign a type/size to the calculated fields?

For instance,

Create Table work_table as (select acct_id, acct_name, 0 acct_amount from acct);

acct_amount is defaulted to number. How could one set that to Number(8,4) during the create table execution? Received on Mon Apr 14 2003 - 18:58:11 CDT