Friday, May 14, 2010

PL /SQL Data Type - Constant

PL SQL has data type called constant. As the name implies, the field with this data type is immutable after declaration.

In the code below, un-commenting the meow line results in error.

declare
const_ruchi constant varchar2(5) :='Ruchi' ;

begin
--const_ruchi :='meow';
dbms_output.put_line('Schema Owner is ' || const_ruchi) ;
end;

No comments:

Post a Comment