today:
5,858
yesterday:
8,868
Total:
6,289,255

PL/SQL Study Code

OUTER.DECLARE

admin 2024.02.03 17:05 Views : 630

DECLARE

 birthdate1 DATE := TO_DATE('29-SEP-70', 'DD-MON-YY');

BEGIN

 DECLARE

 birthdate DATE := TO_DATE('29-SEP-70', 'DD-MON-YY');

 BEGIN

 IF birthdate = birthdate1 THEN

 DBMS_OUTPUT.PUT_LINE ('Same Birthday');

 ELSE

 DBMS_OUTPUT.PUT_LINE ('Different Birthday');

 END IF;

 END;

END;

/

No. Subject Author Date Views
6 NEW TABLE admin 2025.11.16 393
» OUTER.DECLARE admin 2024.02.03 630
4 %TYPE admin 2024.02.02 605
3 IF ... ELSE admin 2024.02.02 627
2 EXCEPTION BLOCK admin 2024.02.02 639
1 OUTPUT SHOWING admin 2024.02.02 620