Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on What is the Default Value within the SQL forums, part of the Databases category; 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?...
|
|||||||
|
|||
|
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; |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Does default constructors gets created in all scenario | RyanJames | C and C++ | 1 | 07-12-2006 05:34 PM |