انا لسه مبتدي وبذاكر sql \pl ونفسي ادخل الامتحان بعد يوم 15\1 لو حد عنده امتحانات يساعدنا علشان انا سمعت انها اتغيرت
المهم
في سوال واجهني وانا بذاكر


Add code to create two bind variables
Create bind variables basic_percent and pf_percent of type NUMBER.
In the executable section of the PL/SQL block assign the values 45 and 12 to basic_percent and pf_percent respectively.

Terminate the PL/SQL block with “/” and display the value of the bind variables by using the PRINT command.
Execute and save your script file as lab_02_05_soln.sql. Sample output is shown below

ارجو الحل مش عارف احله هو موحود في practice 2 السوال 5
.

variable basic_percent NUMBER

variable pf_percent NUMBER
DECLARE
TODAY date:=sysdate;
TOMORROW TODAY%TYPE;
BEGIN
TOMORROW:=TODAY+1;
DBMS_OUTPUT.PUT_LINE('HELLO WORLD');
DBMS_OUTPUT.PUT_LINE(TODAY);
DBMS_OUTPUT.PUT_LINE(TOMORROW);
:pf_percent :=45;
:basic_percent :=12;
END;
/
print basic_percent
print pf_percent