Q:

Write a PL/SQL program to show the uses of a constrained subtype

hamza
Save to bookmark
|
2022-05-18
|
  113 
0

Write a PL/SQL program to show the uses of a constrained subtype.

pl/sql,
login and add your own answer to this question

All Answers

hamza
2022-05-18
need an explanation for this answer? contact us directly to get an explanation for this answer 

DECLARE
 subtype constrained_bi
 IS
 binary_integer range 1..10;
 l_cbi_var1 constrained_bi;
 BEGIN
 l_cbi_var1:=8;
  dbms_output.put_line('The value assigned is:'||to_char(l_cbi_var1));
 END;
/

Sample Output:

The value assigned is:8

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions

need a help?

find thousands of online teachers now