Re: How to create this table?

David Cui wrote:
>
> Hi! netters:
>
> I am trying to do this and can't.
>
> Assume I have a table A. Table has two fields B and C.
> B is a varchar2(6), and C is and thing.
> Now I like to create a new table D with two fields E and F.
> E is a varchar2(8) and F is a date, but E should equal B in fact.
> I try this
>
> create table D as
> select B,
> '01-jan-1996 00:00:00' as F
> from A;
>
> It doesn't work. First it generates Field E as a varchar2(6) instead
> of varchar2(8) and field F is a not a date.
>
> How can I do this?
> Thanks
>
> David

First create table D, then insert rows via select.

Roald.

-- 

+-------------------------------------------------------+
| R.A. van Geleuken                     roald_at_xs4all.nl |
+-------------------------------------------------------+
| There's no such thing as impossibility, only          |
| extremely low chance                                  |
+-------------------------------------------------------+