Anonymous PL/SQL Block Structure:
[DECLARE]
BEGIN
–statements
[EXCEPTION]
END;
Example:
set serveroutput on
VARIABLE X NUMBER;
BEGIN
:X:=11;
DBMS_OUTPUT.PUT_LINE(:X);
END;
/
DECLARE
X NUMBER:=1;
BEGIN
DBMS_OUTPUT.PUT_LINE(X);
END;
/
You may also like
About the author
shohal
I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD