如何在查询中使用AND参数使用AND参数

I have an oracle query that has several parameter, one of the parameter is like an array, the parameter name for example :COLOR. let say I have a table PEOPLEI have an oracle query that has several paramet