Name three types of variables used in PL/SQL. Where are they declared? Give a sample declaration of each.
What will be an ideal response?
Host/bind variable – declared at SQL> prompt, used in PL/SQL block with : prefix
SQL> VARIABLE num NUMBER
Local variable – declared in declaration section of PL/SQL block under keyword
DECLARE.
DECLARE
V_num NUMBER(2);
Substitution varaible – does not need declaration, used with & prefix.
Computer Science & Information Technology
You might also like to view...
Describe how to visualize the following array. How would you identify the location of the 99 that is stored in the array? ? int[][] someNumbers = {{8, 9, 10, 11}, {1, 3, 12, 15}, {5, 9, 44, 99} };
What will be an ideal response?
Computer Science & Information Technology
Comments have an effect on the execution of a procedure.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology