can anyone figureout what exactly is missing in this sql
if ORCHESTRATE.usage = "ALL" and entity_at.id = ORCHESTRATE.id THEN
SELECT * FROM comm_at
ELSE
SELECT * FROM entity_at WHERE end_dt >= sysdate
and entity_at.id = ORCHESTRATE.id
end if;
Not sure what the error is
sql error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am