Integers and Numbers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Integers and Numbers

  1. #1
    Join Date
    Apr 2002
    Posts
    50
    Hi all,

    create table test1(a integer);

    desc test1;
    Name Null? Type
    --------------------- -------- ----------------------------
    A NUMBER(38)

    create table test2(a number(38));

    desc test2;
    Name Null? Type
    -------------------- -------- ----------------------------
    A NUMBER(38)

    select a,vsize(a) from test1;
    A VSIZE(A)
    ----- ----------
    1 2

    select a,vsize(a) from test2;
    A VSIZE(A)
    ----- ----------
    1 2

    In this case, what is the difference between the 2 datatypes ??

    Shiva.

  2. #2
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    No Difference
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Nothing
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Apr 2002
    Posts
    50
    The reason why I had this question was : the front end developers ( in JSP) are using an object to hold the resultset from these tables and they are not able to typecast the value to an Integer (though the field is defined as INTEGER, the reason being it is stored as NUMBER). We are trying to use the same code with SQL Server and there it works fine. I know this is not the right place to post JSP issues, but I wanted to make sure of the Oracle end.

    Thanks,
    Shiva.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width