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_seq
end;
/
insert into foo(data)
values(
insert into foo(id
values(
select * from foo;
From:http://tw.wingwit.com/Article/program/Oracle/201311/17550.html