-
Contributing Member
What is the Default Value
What is the Default value that is what is the default value set for precision and scale in a column defined as NUMBER. Anyone have idea on this?
-
Junior Member
Re: What is the Default Value
The datatype in a declaration can either be constrained or unconstrained. A datatype is constrained when you specify a number which constrains or restricts the magnitude of the value which can be assigned to that variable. A datatype is unconstrained when there are no such restrictions.
And the datatype NUMBER. It supports up to 38 digits of precision -- and uses up the memory needed for all those digits. If your variable does not require this much memory, you could declare a number with a constraint, such as the following:
a NUMBER(1);
b NUMBER(20,5);
Constrained variables require less memory than unconstrained number declarations like this:
c_no_limits_here NUMBER;
-
Contributing Member
Re: What is the Default Value
But could you specify what is the default value set for precision and scale in a column defined as NUMBER.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules