Skip to content

Instantly share code, notes, and snippets.

@xtender
Created June 11, 2014 10:36
Show Gist options
  • Save xtender/ae3bc349c76a429cf6ae to your computer and use it in GitHub Desktop.
Save xtender/ae3bc349c76a429cf6ae to your computer and use it in GitHub Desktop.
additional_jim
begin
insert into chairmanships ( chairperson, date_from, date_to)
values
( 'Jim' , to_date('01-01-2000', 'DD-MM-YYYY') , to_date('01-05-2000', 'DD-MM-YYYY')
);
insert into chairmanships ( chairperson, date_from, date_to)
values
( 'Jim' , to_date('02-05-2000', 'DD-MM-YYYY') , null
);
commit;
end;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment