File: oracle_seq_test.sql

package info (click to toggle)
tntdb 1.4-2
  • links: PTS
  • area: main
  • in suites: forky, sid
  • size: 1,632 kB
  • sloc: cpp: 15,806; makefile: 261; ansic: 260; sql: 158; sh: 11
file content (20 lines) | stat: -rw-r--r-- 353 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
drop table foo;
drop sequence foo_seq;
create table foo
(
    a number not null,
    b integer not null
);
create sequence foo_seq;
create trigger foo_trigger
before insert on foo
for each row
    begin
        select foo_seq.nextval into :new.a from dual;
    end;
/

insert into foo (b) values (3);
insert into foo (b) values (7);

select * from foo;