atmitest/test047_oradb/tables.sql

0001 CREATE TABLE accounts
0002 (
0003         accnum varchar2(50) NOT NULL,
0004         balance number(20,0) NOT NULL,
0005         CONSTRAINT accounts_pk PRIMARY KEY (accnum)
0006 );
0007
0008 -- used for fetch testing
0009 CREATE TABLE account_types
0010 (
0011         typecode varchar2(16) NOT NULL
0012 );
0013
0014 insert into account_types(typecode) values ('AAAA');
0015 insert into account_types(typecode) values ('BBBB');
0016 insert into account_types(typecode) values ('CCCC');
0017 insert into account_types(typecode) values ('DDDD');