FAQ
Totally off Oracle topic.

I am studying the mainframe layout specs for a flat file, and came
across this "datatype", and I just want to confirm my interpretation.

PIC 9(9)V99

So that's 9 digits before the decimal point?

And then two digits after the decimal point?

And the actual data would have a decimal point?

So in this case, for a total of 12 characters?

123456789.99 ?

TIA!!!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
INET: cgrabowy_at_fcg.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Joe Testa at Nov 13, 2002 at 1:48 am
    Chris, I wish i could remember, wait

    var_name number(9,2) heck i can't remember if thats a total of 9 digits
    with 2 to the right, so is it 7.2 or is it 9.2

    damn.

    joe

    Grabowy, Chris wrote:
    Totally off Oracle topic.

    I am studying the mainframe layout specs for a flat file, and came
    across this "datatype", and I just want to confirm my interpretation.

    PIC 9(9)V99
    So that's 9 digits before the decimal point?

    And then two digits after the decimal point?

    And the actual data would have a decimal point?

    So in this case, for a total of 12 characters?

    123456789.99 ?

    TIA!!!

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Joe Testa
    INET: jtesta_at_dmc-it.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Tim Gorman at Nov 13, 2002 at 2:48 am
    Life is too short to try to remember stuff like this...

    SQL> create table x (y number(9,2));

    Table created.

    SQL> insert into x values (999999999.99);
    insert into x values (999999999.99)
    *
    ERROR at line 1:
    ORA-01438: value larger than specified precision allows for this

    column

    SQL> insert into x values (9999999.99);

    1 row created.

    So, that's 9 digits in total with 7 to the left and 2 to the right...

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, November 12, 2002 6:48 PM
    Chris, I wish i could remember, wait

    var_name number(9,2) heck i can't remember if thats a total of 9 digits
    with 2 to the right, so is it 7.2 or is it 9.2

    damn.

    joe


    Grabowy, Chris wrote:
    Totally off Oracle topic.

    I am studying the mainframe layout specs for a flat file, and came
    across this "datatype", and I just want to confirm my interpretation.

    PIC 9(9)V99
    So that's 9 digits before the decimal point?

    And then two digits after the decimal point?

    And the actual data would have a decimal point?

    So in this case, for a total of 12 characters?

    123456789.99 ?

    TIA!!!
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Joe Testa
    INET: jtesta_at_dmc-it.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Gorman
    INET: Tim_at_SageLogix.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Joe Testa at Nov 13, 2002 at 11:08 am
    Tim, thanks thats pretty much what I do everytime someone asks.

    joe

    Tim Gorman wrote:
    Life is too short to try to remember stuff like this...

    SQL> create table x (y number(9,2));

    Table created.

    SQL> insert into x values (999999999.99);
    insert into x values (999999999.99)
    *
    ERROR at line 1:
    ORA-01438: value larger than specified precision allows for this
    column

    SQL> insert into x values (9999999.99);

    1 row created.

    So, that's 9 digits in total with 7 to the left and 2 to the right...

    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, November 12, 2002 6:48 PM



    Chris, I wish i could remember, wait

    var_name number(9,2) heck i can't remember if thats a total of 9 digits
    with 2 to the right, so is it 7.2 or is it 9.2

    damn.

    joe


    Grabowy, Chris wrote:


    Totally off Oracle topic.

    I am studying the mainframe layout specs for a flat file, and came
    across this "datatype", and I just want to confirm my interpretation.

    PIC 9(9)V99
    So that's 9 digits before the decimal point?

    And then two digits after the decimal point?

    And the actual data would have a decimal point?

    So in this case, for a total of 12 characters?

    123456789.99 ?

    TIA!!!

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Joe Testa
    INET: jtesta_at_dmc-it.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Joe Testa
    INET: jtesta_at_dmc-it.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Rachel Carmichael at Nov 13, 2002 at 11:08 am
    see silly stuff like that, my mind traps. Important stuff, like where
    the bar is, my mind loses :)

    stuff like that is what REFERENCE manuals are for... a place in which
    to look up the answer to the "life's too short to remember" questions

    geez, if anyone gave me a SQL test on an interview, I'd probably flunk.
    I'm always looking up syntax.

    Tim Gorman wrote:
    Life is too short to try to remember stuff like this...

    SQL> create table x (y number(9,2));

    Table created.

    SQL> insert into x values (999999999.99);
    insert into x values (999999999.99)
    *
    ERROR at line 1:
    ORA-01438: value larger than specified precision allows for
    this
    column

    SQL> insert into x values (9999999.99);

    1 row created.

    So, that's 9 digits in total with 7 to the left and 2 to the right...

    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, November 12, 2002 6:48 PM

    Chris, I wish i could remember, wait

    var_name number(9,2) heck i can't remember if thats a total of 9 digits
    with 2 to the right, so is it 7.2 or is it 9.2

    damn.

    joe


    Grabowy, Chris wrote:
    Totally off Oracle topic.

    I am studying the mainframe layout specs for a flat file, and came
    across this "datatype", and I just want to confirm my
    interpretation.
    PIC 9(9)V99
    So that's 9 digits before the decimal point?

    And then two digits after the decimal point?

    And the actual data would have a decimal point?

    So in this case, for a total of 12 characters?

    123456789.99 ?

    TIA!!!
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Joe Testa
    INET: jtesta_at_dmc-it.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services

    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like
    subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Gorman
    INET: Tim_at_SageLogix.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    Do you Yahoo!?
    U2 on LAUNCH - Exclusive greatest hits videos
    http://launch.yahoo.com/u2

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Rachel Carmichael
    INET: wisernet100_at_yahoo.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 13, '02 at 1:13a
activeNov 13, '02 at 11:08a
posts5
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase