Anonymous PL/SQL Block

Remarks:

Since they are unnamed, anonymous blocks cannot be referenced by other program units.

An example of an anonymous block

DECLARE
    -- declare a variable
    message varchar2(20);
BEGIN
  -- assign value to variable
  message := 'HELLO WORLD';

  -- print message to screen
  DBMS_OUTPUT.PUT_LINE(message);
END;
/

Contributors

Topic Id: 6451

Example Ids: 22175

This site is not affiliated with any of the contributors.