Anonymous Blocks

Published July 26, 2025 By Sai Sree Ram Gundepudi

Anonymous PL/SQL Blocks

Anonymous blocks are unnamed PL/SQL units that begin with DECLARE or BEGIN.

BEGIN
  DBMS_OUTPUT.PUT_LINE('Hello PL/SQL!');
END;

They are not stored in the database and execute once when run.

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article