Skip to content

Instantly share code, notes, and snippets.

@JubbaSmail
Created December 22, 2014 23:43
Show Gist options
  • Save JubbaSmail/59d8853c33e25c23a1c1 to your computer and use it in GitHub Desktop.
Save JubbaSmail/59d8853c33e25c23a1c1 to your computer and use it in GitHub Desktop.
declare
-- variable_name [CONSTANT] datatype [NOT NULL]
x number:=1;
emp_hiredate date;
emp_deptno number(2) not null := 10;
city varchar2(13) := 'Damascus';
xyz constant number := 1400;
begin
x:=x+1;
emp_hiredate:='13-NOV-14';
dbms_output.put_line(emp_hiredate);
dbms_output.put_line(x);
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment