Why will this statement cause an error the default value


Evaluate the following CURSOR statement:

DECLARE

CURSOR c_1 (p_min_num NUMBER(4) := 100) IS

SELECT col1, col2, col3

FROM tab1

WHERE col15 > p_min_num;

Why will this statement cause an error?

A. The default value (100) cannot be assigned to the p_min_num parameter.

B. The SELECT statement is missing the INTO clause.

C. The size of the p_min_num parameter cannot be specified.

D. All of the above.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Why will this statement cause an error the default value
Reference No:- TGS01651770

Now Priced at $20 (50% Discount)

Recommended (98%)

Rated (4.3/5)