Re: NUMBER-precision in view?

Brief answer to this one:
no, there isn't

Regards,

Sybrand Bakker, Oracle DBA

Håkan Wahlberg <hakan.wahlberg_at_boliden.se> schreef in berichtnieuws 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 13 2000 - 00:00:00 CDT