1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
--drop table tntdbtest;
--drop sequence tntdbtest_seq;
create sequence tntdbtest_seq;
create table tntdbtest
(
id integer not null primary key,
boolcol number(1),
shortcol integer,
intcol number(10),
longcol number(24),
unsignedshortcol integer,
unsignedcol number(10),
unsignedlongcol number(24),
int32col number(10),
uint32col number(10),
int64col number(24),
uint64col number(24),
decimalcol decimal(24, 4),
floatcol binary_float,
doublecol binary_double,
charcol char,
stringcol varchar2(255),
blobcol blob,
datecol date,
timecol timestamp,
datetimecol timestamp
);
create trigger tntdbtest_trigger
before insert on tntdbtest
for each row
begin
select tntdbtest_seq.nextval into :new.id from dual;
end;
/
|
