nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Attempting to create a lookup table, getting syntax error

Mariyam129

SQL Code.txt

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

Find more posts tagged with

Submitted

SQL

OTBI

Status: Submitted

Comments

User_A7H10

@Mariyam129 Did you find solution for this?

I also have requirement to create lookups, Can you please help on this?

Mariyam129

@User_A7H10, sorry, I have still not found a solution