PageRenderTime 27ms CodeModel.GetById 18ms app.highlight 6ms RepoModel.GetById 1ms app.codeStats 1ms

/hippo-migrate/do/00008-do_CreateExperiments.sql

http://hdbc.googlecode.com/
SQL | 26 lines | 21 code | 3 blank | 2 comment | 0 complexity | 8c1a487c1e3f518234fc3a525ec9aac0 MD5 | raw file
 1VARIABLE v_pk  NUMBER;
 2
 3BEGIN
 4    hippo.sp_log_version_change_begin('00008-do_CreateExperiments.sql', &1, :v_pk);
 5END;
 6/
 7
 8---- ddl below ------------------------------------------
 9CREATE TABLE hippo.experiments(
10	experiment_cd 		number CONSTRAINT pk_experiments PRIMARY KEY,
11	type 				varchar2(16 char),
12	title				varchar2(64 char) NOT NULL,
13	purpose				varchar2(128 char) NOT NULL,
14	method				varchar2(4000 char),
15	conclusion			varchar2(4000 char)
16);
17---------------------------------------------------------
18
19BEGIN
20    hippo.sp_update_version(8);
21    hippo.sp_log_version_change_finish(:v_pk, 'success');
22EXCEPTION
23    WHEN OTHERS THEN
24        hippo.sp_log_version_change_finish(:v_pk, 'fail');
25END;
26/