1.

Can A Variable Be Assigned A Value From Database? If Yes, Then How?

Answer»

Yes, a variable can be ASSIGNED a value from a database. You can FETCH the value from the database and ASSIGN it to the variable using the into keyword, as shown in the following CODE:

SELECT emp_sal * 0.20 into var_increment from t_emolovee where emo_no = emo_id

Yes, a variable can be assigned a value from a database. You can fetch the value from the database and assign it to the variable using the into keyword, as shown in the following code:



Discussion

No Comment Found