Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Adding Case Statement to Existing Data Model
Summary
Need assistance with case statementContent
I am in need of assistance with the following: (1) case statement syntax and (2) adding a case statement to an existing data model
My goal is to create a new field in an existing data model named ‘Score’. The values in this field (Green, Yellow and Red) depends on the total score (see case statement below). The Total Score field is already in the existing data model. I then want to use this new field ‘Score’ as a parameter.
Here is the case statement - there is something wrong with the syntax:
SELECT TOTAL_SCORE
Tagged:
1