Default behaviour SQL

create table choice_architecture (
  im_opt_out_by varchar2(100) default 'so most will have this value',
  but_we_are_opt_in varchar2(100),
  so_often_have_no_value_set varchar2(100),
  unless_we_constraint_us_as varchar2(100) not null

insert into choice_architecture (unless_we_constraint_us_as) 
values ('In which case we''re forced into making a decision!');

select * from choice_architecture ;

drop table choice_architecture purge;

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>