Theaccountsreceivabledepartmentrequestedanaccountsstatustoallowuserstoentereitheracustomername,customernumber,customerphonenumberandthendisplaythecustomeroutstandingbalance.Youwanttorestrictthedataretrievedbasedonvaluesenteredbytheusers.Whichwhereclausewouldyouwriteinthequerytoselectstatementtoaccomplishthistask?（）A.&p_where_clause&ensp;B.:p_where_clause C.WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone D.Where cust_ID=&p_custid&ensp;cust_name=&p_cust_name&ensp;or cust_phone=&p_cust_phone

单项选择题

The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）

A.&p_where_clause
B.:p_where_clause
C.WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone
D.Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone

1Z0-132