Post reply

Datatype from Oracle to SQL

  • October 12, 2011 at 7:53 am

    #246462

    Hello Friends,...

    I am working on datatype conversion from oracle to sql but i am little confused on a specific datatype...

    In oracle i have a datatype " number(7)" and in sql i am using " int "... Does that look right to you guys?? Please suggest

  • October 12, 2011 at 8:09 am

    #1393472

    done something very similar myself when porting our schemas to oracle equivilents.

    i've always used NUMBER(10) for integers;

    and here's the reference i used for my conversions:

    http://download.oracle.com/docs/cd/B19306_01/gateways.102/b14270/apa.htm

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 12, 2011 at 9:55 am

    #1393558

    Thank you so much Lowell....that was really helpful

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply