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

Thread: updating sql

Hybrid View

  1. #1
    Join Date
    Apr 2007
    Posts
    24

    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
    Location
    Pittsburgh, PA
    Posts
    4,021
    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
    Posts
    24

    Update

    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