ORA-00905: missing keyword in case statement

I am getting ORA-00905: missing keyword in case statement in my when clause. Below is the query. vsqlstr := ‘select name, enrollement_dt,case_name, dept, subject, city, state, zip from enrollement …

JPA and 1000 ID use in Oracle IN Operator

I use NamedNativeQuery for delete rows, and it’s somthing like this: DELETE from FAKTOR where ID IN ( select fa.ID from FAKTOR fa left join FAKTOR_REASON fars on fa.FARS_ID = fars….