dbms_output

How Do You Assign A Selected Value To A Variable In Oracle?

by

How Do You Assign A Selected Value To A Variable In Oracle? First, declare a variable l_customer_name whose data type anchors to the name columns of the customers table. … Second, use the SELECT INTO statement to select value from the name column and assign it to the l_customer_name variable. Third, show the customer name