How can I do a conditional SQL?

tsangsir

https://community.oracle.com/tech/developers/discussion/comment/16819982#Comment_16819982

Sorry I should meant :is_admin instead of :is_admin = 1

But you should have noticed your issue. When :is_admin = 0, your comparison between FETAX, sys_context('APEX$SESSION','APP_USER') and user will not match. 

BluShadow

https://community.oracle.com/tech/developers/discussion/comment/16819984#Comment_16819984

Sure, in Apex the fields on the screen are often strings and you sometimes need to use TO_DATE to convert to a date datatype, but using TO_DATE(TO_DATE... is clearly wrong. You wouldn't try and convert something that is already converted to a date, to a date again.

L. Fernigrini

Based on the images, you are trying to assign the value to :is_admin in the same "sentence" as the query.

Replace :is_admin with the logic you are trying to assign to it directly on the SELECT and it should work. (remove line 1 and use that logic on lines 26 and 27)

Edisson Gabriel López

https://community.oracle.com/tech/developers/discussion/comment/16820089#Comment_16820089

Thank you very much it served me, I had not thought about it.