The four PL/SQL steps necessary for explicit cursor processing are as follows. Declare the cursor. Open the cursor for a Query. Fetch the results into PL/SQL variables. Close the Cursor.
when ever i run the anonymous plsql block, sql*plus request me enter the parameter input value
I have a variable value like customer_name='xxxcust & lt pvt'
please help me