--example 1
DECLARE
id number(10) := 5;
BEGIN
IF id = 5 THEN
dbms_output.put_line('Value is 5');
END IF;
END;
--example 2
DECLARE
id number(10) := 5;
BEGIN
IF id = 1 THEN
dbms_output.put_line('Value is 1');
elsif id = 5 THEN
dbms_output.put_line('Value is 5');
end if;
END;
--example 3
DECLARE
id number(10) := 5;
BEGIN
IF id = 1 THEN
dbms_output.put_line('Value is 1');
elsif id = 5 THEN
dbms_output.put_line('Value is 5');
else
dbms_output.put_line('Value not found');
end if;
END;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter