Re: Number coulmn in View

This will not work. Cannot specify data type in the definition of a View!!

Thanks

Niall Litchfield wrote:

> Unchecked
> create or replace view new_view
> (
> id number(8),
> quantity number(8),
> month
> )
> as select
> id,
> quantity,
> month
> from table1;
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
Received on Mon Oct 01 2001 - 12:24:56 CDT