Theaccountsreceivabledepartmentrequestedanaccountsstatustoallowuserstoentereitheracustomername,customernumber,customerphonenumberandthendisplaythecustomeroutstandingbalance.Youwanttorestrictthedataretrievedbasedonvaluesenteredbytheusers.Whichwhereclausewo
题目
Theaccountsreceivabledepartmentrequestedanaccountsstatustoallowuserstoentereitheracustomername,customernumber,customerphonenumberandthendisplaythecustomeroutstandingbalance.Youwanttorestrictthedataretrievedbasedonvaluesenteredbytheusers.Whichwhereclausewouldyouwriteinthequerytoselectstatementtoaccomplishthistask?（）
A.&p_where_clause
B.:p_where_clause
C.WHERECUST_ID=P_CUST_IDorcust_name=:p_cust_nameorcust_phone=:p_cust_phone
D.Wherecust_ID=&p_custidcust_name=&p_cust_nameorcust_phone=&p_cust_phone