Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Unanswered: money fromat in sql

    what money fromats there are in sql??

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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
    Aug 2011
    Posts
    3

    sql: I can not raise a decode function withthe condition. how I can do? I need to do

    I need to do a sql query:

    list employees with an increase in his salary with the following conditions:

    if your salary is less than 4000 but higher than 1000 assign it an increase of 15% of their salary.
    if your salary is greater than 4000 assign it an increase of 20% of their salary.


    Thanks for your help!

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Quote Originally Posted by juaritoz View Post
    I need to do a sql query:

    list employees with an increase in his salary with the following conditions:

    if your salary is less than 4000 but higher than 1000 assign it an increase of 15% of their salary.
    if your salary is greater than 4000 assign it an increase of 20% of their salary.
    I fail to see how this relates to "what money fromats there are in sql??"

  5. #5
    Join Date
    Mar 2007
    Posts
    623
    Quote Originally Posted by juaritoz View Post
    I can not raise a decode function withthe condition. how I can do?
    Why do you not use CASE expression instead? Is using DECODE part of your homework assignment?

    Anyway, it is possible to use SIGN function in DECODE to distinguish range. Following thread on OraFAQ deals with it more deeply: http://www.orafaq.com/forum/t/47024/2/

  6. #6
    Join Date
    Aug 2011
    Posts
    3

    thanks

    [/HTML]
    Quote Originally Posted by flyboy View Post
    Why do you not use CASE expression instead? Is using DECODE part of your homework assignment?

    Anyway, it is possible to use SIGN function in DECODE to distinguish range. Following thread on OraFAQ deals with it more deeply: OraFAQ Forum: SQL & PL/SQL Decode & Sign statements concepts.

    thanks for your comment ... and solved the problem with the function case

Posting Permissions

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