PL/SQL Programming

PL/SQL Programming one: Preface

II: PL/SQL Overview

Two--1:PL/SQL block structure

  1 "declare"  2--declaration section, optional   3 begin  4--execution part, must   5 [exception]  6--Exception handling section, optional   7 End

1Sql> set serveroutput on;2Sql>3Sql> Declare42 a int:=10;53 b int:=200;64 c number;75 begin86 c:= (A+B)/(A-B);97 Dbms_output.put_line (c);Ten8 exception One9 when Zero_divide Then ATen Dbms_output.put_line ('the divisor is forbidden to zero .‘); -one end; -12/ the  --1.10526315789473684210526315789473684211 -  -PL/SQL procedure successfully completed +  -Sql>

View Code

Two--2: code comments and identifiers

——————————————

——————————————————————————————————————————————————————————

PL/SQL Programming