SQL query help - If statement in where
- or -
Post a project like this2488
£20(approx. $25)
- Posted:
- Proposals: 3
- Remote
- #1610034
- Awarded
Description
Experience Level: Intermediate
General information for the business: Online
Database management system (DBMS): Oracle
Description of requirements/functionality: I am looking for someone who is online and ready to work in the next hour or so. Please let me know availability when replying to this ad.
I have a freeform option in my database. {FREE_FORM}
I have various where clauses. One of which is
AND fruit = XXX
I can manually type in fruit = apple but I want it to be dependant on the Free Form tag.
I would like that where clause to be...
If {FREE_FORM} = 1 THEN fruit = apple
If {FREE_FORM} = 2 THEN fruit = cherry
If {FREE_FORM} = 3 THEN fruit = pear
If {FREE_FORM} = 4 THEN fruit = banana
Can you help?
Extra notes: As mentioned above. I need someone to start working in about an hour (around 1pm UK time). I can't give DB access so we both need to be online at the same time.
Database management system (DBMS): Oracle
Description of requirements/functionality: I am looking for someone who is online and ready to work in the next hour or so. Please let me know availability when replying to this ad.
I have a freeform option in my database. {FREE_FORM}
I have various where clauses. One of which is
AND fruit = XXX
I can manually type in fruit = apple but I want it to be dependant on the Free Form tag.
I would like that where clause to be...
If {FREE_FORM} = 1 THEN fruit = apple
If {FREE_FORM} = 2 THEN fruit = cherry
If {FREE_FORM} = 3 THEN fruit = pear
If {FREE_FORM} = 4 THEN fruit = banana
Can you help?
Extra notes: As mentioned above. I need someone to start working in about an hour (around 1pm UK time). I can't give DB access so we both need to be online at the same time.
Larry K.
100% (12)Projects Completed
22
Freelancers worked with
19
Projects awarded
34%
Last project
10 Oct 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies