Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Constraints / Checks
mod(<column>,5000) = 0
Hth,
--
Sybrand Bakker, Oracle DBA
Jonathan Stein [Darklite-SCE] <stein_at_darklite-sce.com> wrote in message
news:7ud0jv$ohe$1_at_fraggle.esatclear.ie...
> Hi all,
>
> I need to know how to word a constraint/check that will only allow
> real-numbers divisible by 5000 to be inserted into a table.... any one
> help - to work with pl/sql on oracle 8.
>
> Thanks
> --
> Jonathan Stein
> Creative & Technical Director
> Darklite-SCE: Global Web Solutions
> E-Mail: stein_at_darklite-sce.com
> Phone: 353 43 48721 * Fax: 353 43 45928 * Mobile: 353 87 2815298
> Dundoons, Farnagh Hill, Longford, Co Longford, Ireland.
>
> ------------------------------------------------------------------------
> http://www.darklite-sce.com/ - Darklite-SCE Home
> http://design.darklite-sce.com/ - Darklite-SCE Design Services
> http://hosting.darklite-sce.com/ - Darklite-SCE Hosting Services
> http://free.darklite-sce.com/ - Darklite-SCE Free Services
> ------------------------------------------------------------------------
>
>
Received on Sun Oct 17 1999 - 15:30:22 CDT