As I understand it, the only way to convert a long data type to VarChar2 is within PL/SQL. But then how can I create a query that looks inside that field for specific values?
In short we have a table that holds some audit information about various emails that went out. The field that holds the list of email addresses is a LONG datatype.
Now I want to:
Select * from MY_EMAIL_AUDIT_TBL where Emails_Sent like '%TAD@email.com%'
But I can't do that because Emails_Sent is of type long and I get a data conversion error.