Explicit char column definitions in create table as select?

Is it possible to force Oracle to create a specific type and length of character
when creating a table using select.

Like -

create table test1 as select substr(col_code,1,3) col13_code from basetab;

This will create a varchar2 (3) column even if col_code is char.

Can the type be forced to char without using alter table nor pre-creating the table?

Any help appreciated.

Thanks
Neville Received on Fri Jul 16 1999 - 09:32:18 CDT