Index | Home | Forums
Oracle PL/SQL Example 2-17 Using a Label Qualifier With Identifiers

Example 2-17 Using a Label Qualifier With Identifiers

<<outer>>
DECLARE
   birthdate DATE := '09-AUG-70';
BEGIN
   DECLARE
      birthdate DATE;
   BEGIN
      birthdate := '29-SEP-70';
      IF birthdate = outer.birthdate THEN
         DBMS_OUTPUT.PUT_LINE ('Same Birthday');
      ELSE
         DBMS_OUTPUT.PUT_LINE ('Different Birthday');
      END IF;
   END;
END;
/


This page was created by oracleabc.com on Feb 23,2008 00:09:02
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here