Results 1 to 5 of 5

Thread: Math Power

  1. #1
    Join Date
    Oct 2011
    Posts
    16

    Question Unanswered: Math Power

    Does Anyone Know How to do a Math Operation such getting the percentage Out of a Query For Instance If i Wanted to Update the credit Limit of ALL customers By A 25% i guess i would go by :

    UPDATE Customers
    SET CreditLimit = ??????

    How would i tell Oracle to do everyones On a 25% More of what they already have?
    By the way i noticed on my last thread My query wasnt formatted It seems its auto formatted when i submit the post Ill figure out a way for it to show on a porper more readable format for everyone.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    UPDATE customers
    SET    creditlimit = creditlimit * 1.25;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2011
    Posts
    16

    :o

    You Must Be some sort of Oracle King :P

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Ill figure out a way for it to show on a porper more readable format for everyone.

    use <code_tags> is explained in #1 STICKY post (URL below)
    http://www.dbforums.com/oracle/10316...s-posters.html
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2011
    Posts
    16

    Yei

    Thanks a lot for the help you must be admin :O

Posting Permissions

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