PL/SQL-Package and query with single quote and comma
Hi all,
I faced to a problem with a query with apostrophe and single quote.
I want to create a query in this form, e.g.:
Select *
From my_table
where my_col_1 in (:my_variable)
and before that :my_variable (VARCHAR2) will be initialaized:
1- :my_variable := 'content_1'
2- :my_variable := my_variable || ', content_2'
....
finally, query have to be as followed:
Select *
From my_table
--where my_col_1 in (:my_variable)
where my_col_1 in ('content_1','content_2')
But query could not work with ' (apostroph). I get no error, but not the correct answer, that I checked manually.