File: oracle-test.sql

package info (click to toggle)
tntdb 1.3-2
  • links: PTS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 3,044 kB
  • ctags: 2,387
  • sloc: cpp: 14,250; sh: 11,084; makefile: 252; ansic: 144; sql: 106
file content (33 lines) | stat: -rw-r--r-- 720 bytes parent folder | download | duplicates (3) 
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
 
--drop table tntdbtest;
--drop sequence tntdbtest_seq;

create sequence tntdbtest_seq;
create table tntdbtest
(
  id integer not null primary key,
  boolcol number(1),
  intcol number(10),
  longcol number(24),
  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;
/