W Revisit Later

Select an option

Arthur is requested to handle a requirement from the client in which the number of columns selected for a query or the number of bind variables set is not known until run time.

Among the following options, which is the best fit to meet the requirement?

Native Dynamic SQL $($NDS$)$

only $2$

Using the DBMS$\_$SQL package

Only $1$

nily $2$

Either $1$ or $2$

Neither $1,2$