Hello,
I want to filter a table with a WHERE clause (PAYS='France' and VILLE ='Paris' ) , but I want to put the filter in a table.
I have a table which contain a filter. It looks like :
--------------------------------------------------------------
l FILTER l
---------------------------------------------------------------
l PAYS='France' and VILLE ='Paris' l
---------------------------------------------------------------
So at the end, I want to filter the table TABLE_FINAL as :
delete from TABLE_FINAL where = PAYS='France' and VILLE ='Paris' .
But the issue is that i cannot to do this : Can i use PL&SQL or not ?
Because the problem is that i obtain : delete from TABLE_FINAL where = 'PAYS='France' and VILLE ='Paris''
Thanks