pkl wrote:
> Mark D Powell wrote:
> > Ranko, Daniel is correct in that your subject line is not a clear
> > question. Do you mean is there a limit to how many check constraints
> > or FK constraints you can define on a table?
> >
> > The Oracle version is often important since limits change over time and
> > many features require a certain version of Oracle. Bugs are also often
> > version specific down to the dot level.
> >
> > HTH -- Mark D Powell --
> >
> Well, I think the question of the OP is quite clear.
> So, Ranko, there is no Oracle version, I am aware of, where there
> are *predifined* constants, which denote the largest (and
> smallest) possible available numbers.
> However, you might be able to define such constants for yourself.
>
> hth - peter
Why on Earth would there be a predefined Oracle constant that denoted a
very large number? How large did you have in mind anyway? I can't
imagine a use for rpad('9',38,'9'), and in any case couldn't you use
1e39?
Received on Mon Nov 28 2005 - 17:53:23 CST
