hi,
i have a table called rule

the column in it is varchar2(1000) and the value is
RELIGION = 'HIN' AND NATIONALITY = 'QTY'

I HAVE another table details.

which has columns like
employee_no,religion,nationality


i write following pl/sql

select rule
into x_rule
from rule;

next is

select count(*)
into x_cnt
from details
where employee_no = '29' ||' and '|| x_rule

can i use the x_rule with concationation.
it doesn't give proper results event though the conditions are existing.
is there any alternate for this?

please expalin