Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Attempting to create a lookup table, getting syntax error

Mariyam129
Rank 2 - Community Beginner
I am attempting to use SQL to create a report that determines whether a procurement was completed late or not depending on a number of factors.
Due to the many conditions that need to be defined, I am attempting to use a lookup table to make it more efficient. However, I am encountering a number of errors when i try to make the report.
I would appreciate if you could confirm if this method is possible, and if so could look over my the code and suggest any fixes,
Thank you
1
Comments
-
@Mariyam129 Did you find solution for this?
I also have requirement to create lookups, Can you please help on this?
0 -
@User_A7H10, sorry, I have still not found a solution
0