Write a PL/SQL block to find whether the given year is leap year or not

Question

It has to be executed in mysql workbench please do provide solution if you know it 🙏

Answer 1

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;

Answer 2

Showing error in mysql workbench should I have to copy paste as it is?

Answer 3

Yeahh!

Answer 4

2017

Answer 5

write a pl/sql block to display a particular item details display appropriate message if the item is not found