conn scott/tiger@powermis
drop table foo;
create table foo(
id number primary key
data varchar());
create sequence foo_seq;
create or replace trigger bifer_foo_id_pk
before insert
on foo
for each row
begin
select foo_seqnextval into :newid from dual;
end;
/
insert into foo(data)
values(Chirstopher);
insert into foo(iddata)
values(Sean);
select * from foo;
