Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: Round function in oracle PL/SQL

    Hi all,

    I updating a column in a table but want to limit the number of decimal places. Will I be able to do it like this?

    Update tab1 set COL1 = COL3+COL4

    I wrote something like this but it throws an error.
    Update tab1 set ROUND(COL1,6) = COL3+COL4

    Any suggestions will be greatly appreciated.

    Thanks,
    Nandinir

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Move the function to the RIGHT side of the equation sign.

  3. #3
    Join Date
    Jul 2005
    Posts
    276
    Thank you so much....!! That helps.

Posting Permissions

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