0 votes
in PL/SQL by
Can A Variable Be Assigned A Value From Database? If Yes, Then How?

1 Answer

0 votes
by

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

Related questions

0 votes
asked Mar 15, 2021 in PL/SQL by Robindeniel
0 votes
asked Mar 13, 2021 in PL/SQL by rajeshsharma
...