|
Table
|
Query
|
|
OA_TABLES
|
INSERT INTO OA_TABLES (
TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, TABLE_TYPE, TABLE_STRUCT, TABLE_PATH, OA_USERDATA, OA_SUPPORT, REMARKS
)
VALUES (
'SCHEMA', 'OAUSER', 'CURVALUE', 'TABLE', 'CVA', null, null, null, 'Current value table'
);
|
|
OA_COLUMNS
|
INSERT INTO OA_COLUMNS (
TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME,COLUMN_NAME, DATA_TYPE, TYPE_NAME, OA_LENGTH, OA_PRECISION, OA_RADIX, OA_SCALE, OA_NULLABLE, OA_SCOPE, OA_USERDATA, OA_SUPPORT, PSEUDO_COLUMN, OA_COLUMNTYPE, REMARKS
)
VALUES(
'SCHEMA', 'OAUSER', 'CURVALUE', 'TAG', 1, 'CHAR', 12, null, null, null, 0, null, null, null, 1, 0, 'Tag name'
);
|
|
OA_STATISTICS
|
INSERT INTO OA_STATISTICS(
TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, NON_UNIQUE, INDEX_QUALIFIER, INDEX_NAME, OA_TYPE, SEQ_IN_INDEX, COLUMN_NAME, OA_COLLATION, OA_CARDINALITY, OA_PAGES, FILTER_CONDITIONS
)
VALUES(
'SCHEMA', 'OAUSER', 'CURVALUE', 0, null, 'TAGINDX', 3, 1, 'TAG', 'A', null, null, null
);
|
|
OA_FKEYS
|
INSERT INTO OA_FKEYS(
PKTABLE_QUALIFIER, PKTABLE_OWNER, PKTABLE_NAME, PKCOLUMN_NAME, FKTABLE_QUALIFIER, FKTABLE_OWNER, FKTABLE_NAME, FKCOLUMN_NAME, KEY_SEQ, UPDATE_RULE, FK_NAME, PK_NAME
)
VALUES(
'SCHEMA', 'OAUSER', 'CURVALUE', 'TAG',
'SCHEMA', 'OAUSER', 'TAGDIR', 'TAG',
1, null, null, null
);
|
|
OA_PROC
|
INSERT INTO OA_PROC(
OA_QUALIFIER, OA_OWNER, OA_NAME, NUM_INPUT_PARAMS, NUM_OUTPUT_PARAMS, NUM_RESULT_SETS, REMARKS, PROCEDURE_TYPE, OA_USERDATA
)
values (
'SCHEMA', 'OAUSER', 'SALARY', NULL, NULL, NULL, 'Salary compute', 1, 's=a+b-c'
);
|
|
OA_PROCCOLUMNS
|
INSERT INTO OA_PROCCOLUMNS (
OA_QUALIFIER, OA_OWNER, OA_NAME, COLUMN_NAME, OA_COLUMNTYPE, DATA_TYPE, TYPE_NAME, OA_LENGTH, OA_PRECISION, OA_RADIX, OA_SCALE, OA_NULLABLE, OA_USERDATA, REMARKS
)
VALUES(
'SCHEMA', 'OAUSER', 'SALARY', 'TOTAL', 0,1, 'CHAR', 12, null, null, null, 0, null, 'Current salary'
);
|