Re: NUMBER-precision in view?

Of course, You're right. Thanks!
/Håkan W

spencer wrote:

> in the view definition, i'm wondering about expression:
>
> DECODE(code, 'CODE', 'GAI', 'GAI') AS SITECODE,
>
> isn't this equivalent to the expression:
>
> 'GAI' AS SITECODE,
>
> ? the way the decode expression reads to me is:
> if code = 'CODE' then return 'GAI' else return 'GAI' end-if
> what am i missing here ?
>
> "Håkan Wahlberg" <hakan.wahlberg_at_boliden.se> wrote in message
> news:38F601CC.869FAAB6_at_boliden.se...
> > Creating av view like this:
> >
> >
> > CREATE OR REPLACE VIEW DHG9GCOMPOSIT ( MSLINK,
> > SITECODE, DHNUMBER, S_START, S_END,
> > X, Y, Z, CODE,
> > AU, AG, CU, ZN,
> > PB )
> > AS SELECT
> > ROUND(id*100000+sect_start*100) AS MSLINK,
> > DECODE(code, 'CODE', 'GAI', 'GAI') AS SITECODE,
> > id AS dhnumber,
> > sect_start AS s_start,
> > sect_end AS s_end,
> > northing AS x,
> > easting AS y,
> > z,
> > code,
> > au, ag, cu, zn, pb
> > FROM BLG9GCOMPOSIT
> >
> > gives data:lenght, data_precision and data_scale 0 (zero) on
 first
> > column, MSLINK.
> > Is there a way to excplicit define this in a view? Something
 like
> > CREATE OR REPLACE VIEW DHG9GCOMPOSIT ( MSLINK NUMBER(10,3),
> > SITECODE, DHNUMBER, S_START, S_END ....etc
> >
> > Thanks in advance for any answer.
> > /Håkan Wahlberg
> >
> >
> >
> >
Received on Thu Apr 20 2000 - 00:00:00 CDT