Results 1 to 3 of 3

Thread: What is the Default Value

  1. #1
    Contributing Member
    Join Date
    Jul 2006
    Answers
    57

    Question 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?


  2. #2
    Junior Member
    Join Date
    Oct 2006
    Answers
    24

    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;


  3. #3
    Contributing Member
    Join Date
    Jul 2006
    Answers
    57

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact