DECLARE
a int;
b int :=10;
j int;
BEGIN
j:=0;
WHILE j<=b LOOP
b:=b-1;
IF b>j THEN
a=b-j;
DBMS_OUTPUT.PUT_LINE(' b is greater than j');
END IF;
IF j<b THEN
a=j+b;
DBMS_OUTPUT.PUT_LINE(' j is less than b');
END IF;
IF j>b THEN
a=j+b;
DBMS_OUTPUT.PUT_LINE(' now j is great than b');
END IF;
IF j== b THEN
DBMS_OUTPUT.PUT_LINE(' OHHH!!! WOW! ');
END IF;
END LOOP;
DBMS_OUTPUT.PUT_LINE(' This is the content of a ' || a');
END;
/😀 first we have to correct this PL/SQl Code there after we have changed it we correct questions related to it.
Write a PL/SQL program to retrieve the content (all) of faculty table. The following is the structure of faculty table:
| F_id | F_description |
|---|---|
| primary key, int, not null | varchar(55) not null |
@cizamihigo