PL/SQL DataType: Program to show the uses of SIMPLE_INTEGER datatype
PL/SQL DataType: Exercise-6 with Solution
Write a PL/SQL program to show the uses of SIMPLE_INTEGER datatype.
Sample Solution:
PL/SQL Code:
DECLARE
num SIMPLE_INTEGER := 2147483645;
BEGIN
FOR j IN 1..4 LOOP
num := num + 1;
DBMS_OUTPUT.PUT_LINE(TO_CHAR(num, 'S9999999999'));
END LOOP;
FOR j IN 1..4 LOOP
num := num - 1;
DBMS_OUTPUT.PUT_LINE(TO_CHAR(num, 'S9999999999'));
END LOOP;
END;
/
Flowchart:
Sample Output:
+2147483646 +2147483647 -2147483648 -2147483647 -2147483648 +2147483647 +2147483646 +2147483645 PL/SQL procedure successfully completed.
In the above example the initial value is 2147483645, when this value reach in upper limit it started from starting value.
Improve this sample solution and post your code through Disqus
Previous: Write a PL/SQL program to show the upper limit of PLS_INTEGER.
Next: Write a PL/SQL program to show the uses of an unconstrained subtype, i.e., the same set of values as its base type.
What is the difficulty level of this exercise?
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://www.w3resource.com/plsql-exercises/datatype/plsql-datatype-exercise-6.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics