How do you reduce the chances of SQL injection for the procedure?

View the Exhibit.

How do you reduce the chances of SQL injection for the procedure?

View the Exhibit.

How do you reduce the chances of SQL injection for the procedure?

A.
Execute the SQL statement in V_STMT as dynamic SQL.

B.
Remove the default value for the arguments in the procedure.

C.
Convert the condition in the WHERE clause to be accepted from the user and concatenated.

D.
Convert the SELECT statement to static SQL, placing the value of P_EMAIL into a local
variable.



Leave a Reply 1

Your email address will not be published. Required fields are marked *