DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: updating sql

  1. #1
    Join Date
    Apr 2007

    updating sql

    In Oracle 7.3.4, how do I update the number field(10,2) to a negative value?

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    Its been so long sine I looked at 7.3.4. Why can't you just update table1 set num1=num1*-1 where num1>0; or something like that. Then you can start reading the "10g before you install guide" and start considering how you are going to migrate to 10gR2.
    this space intentionally left blank

  3. #3
    Join Date
    Apr 2007


    Thanks for you reply. I will test it out.
    My company is very happy with 7.3.4 and do not plan to move to any other version for some more time or until everything crashes.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.