Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    5

    Unanswered: numeric funtion in oracle.

    Hi ,

    I need to convert DB2 funtion "Decimal(number,pression,scale)" into oracle

    Do someone help me..

    Thanks in advance,
    Sri.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Sure. Only if I knew what function "Decimal(number,pression,scale)" does.

    In other words: if you are too lazy to read Oracle manual(s), I'm too lazy to read DB2 manual(s). Although there might be people who know both Oracle and DB2 to answer your question instantly, I wouldn't hold my breath.

  3. #3
    Join Date
    Jan 2007
    Posts
    5
    thank your information.

    Decimal returns numeric value depanding upon persicion and scale.

    any below is the answer for my question.

    to_char(<column>,format) ie to_char(1234,'99.99')

Posting Permissions

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