My table I feed the data from another database. That source database now changed one column value from
Active, So my query doesn't return results.
I want to handle this in the query by ignoring the case.
I have the where clause with
IN function like below.
Select * from myTabble Where mytable.status in ('ACTIVE')
Can someone help me to use this query by ignoring case sensitivity. Also I can do one thing. When insert from that source, I can turn the
ACTIVE. I tried that with
upper(sourcedata.status) in the
query but it didn't work.