This content has been marked as final. Show 3 replies
Global variable are forms specifice variable.
it can store character value upto 255 for all usages.
We can initialize it when we declare otherwise give error if we did not assign it any value.
Oracle 10g it can take upto 4000 bytes
GLOBAL.ur_globalvar := TO_CHAR(15); or :GLOBAL.ur_globalvar:= '15'; or Remmber numeric values are implicitly converted by oracle 2 character :GLOBAL.ur_globalvar:= 15; -- which can then subsequently be accessed using... :GLOBAL.ur_globalvar; -- To destroy a global variable and release its memory, use the ERASE built-in procedure: Erase('GLOBAL.my_var');