Skip to content

Instantly share code, notes, and snippets.

@JubbaSmail

JubbaSmail/pl_sql_if_Statement.sql

Created December 22, 2014 23:42
Show Gist options
  • Save JubbaSmail/ad2133519ce441234fbd to your computer and use it in GitHub Desktop.
Save JubbaSmail/ad2133519ce441234fbd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pl_sql_if_Statement.sql
declare
x number:=4.5;
begin
if x > 5 then
dbms_output.put_line(x || ' is big');
elsif x < 5 then
dbms_output.put_line(x || ' is small');
else
dbms_output.put_line(x || 'equal 5');
end if;
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment