DSXchange

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

You should avoid using * in the select. Better use the column names along with the alias.

I think you can debug also faster.

Regards
Sreeni

Sreenivasulu wrote:You should avoid using * in the select. Better use the column names along with the alias.

I think you can debug also faster.

Regards
Sreeni

thanks for the reply Sreeni...infact i have try that too but i guess something is missing the sql itslef.

Hard to say unless you post the actual error. Your db supports if-then-else constructs?