Question

Write a PL/SQL block to find whether the given year is leap year or not
Has to be executed in mysql workbench pls do provide solution if you know it​

Answer 1

Explanation:

DECLARE

year NUMBER := 2012;

BEGIN

IF MOD(year, 4)=0

AND

MOD(year, 100)!=0

OR

MOD(year, 400)=0 THEN

dbms_output.Put_line(year || ' is leap year ');

ELSE

dbms_output.Put_line(year || ' is not leap year.');

END IF;

END;