Re: Repost: Setting view column datatype

From: Brian Dick <bdick_at_cox.net>
Date: Thu, 5 Feb 2004 21:02:21 -0500
Message-ID: <JACUb.2563$Yj.1679@lakeread02>

Doesn't work. But thanks anyways. Here is the example from my original post again. Notice that the column datatype of the view is NUMBER when it should be NUMBER(5).

ORA> create or replace view foo
2 as
3 select cast(1 * rownum as number(5)) an_expression 4 from dual

View created.

ORA> desc foo

 Name                          Null?    Type
 ----------------------------- -------- --------------------
 AN_EXPRESSION                          NUMBER

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1075443349.850748_at_yasure...
> Brian Dick wrote:
>
> > Can anyone help on this?
> >
>
> CAST. http://www.psoug.org/reference/cast.html
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Thu Feb 05 2004 - 20:02:21 CST