Re: alter view???

From: <olimar2_at_my-deja.com>
Date: Tue, 26 Sep 2000 18:36:31 GMT
Message-ID: <8qqqdc$rt6$1@nnrp2.deja.com>

In article <8qqnq6$5nk$1_at_nnrp1.deja.com>, hajir_at_my-deja.com wrote:
> does this work?
>
> ALTER VIEW HAJIR4 MODIFY WK_END (DATE)
>
> ERROR at line 1:
> ORA-00922: missing or invalid option
>
> currently in view HAJIR4, WK_END is in VARCHAR format.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

You can try this:
CREATE OR REPLACE VIEW HAJIR4
AS SELECT TO_DATE(WK_END) FROM <Table name>;

Hope it help

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 13:36:31 CDT