PageRenderTime 17ms CodeModel.GetById 5ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 0ms

/hippo-migrate/do/00016-do_RenameConcludedToActive.sql

http://hdbc.googlecode.com/
SQL | 20 lines | 15 code | 3 blank | 2 comment | 0 complexity | c3680500514676bd2e45abe438f329da MD5 | raw file
 1VARIABLE v_pk  NUMBER;
 2
 3BEGIN
 4    hippo.sp_log_version_change_begin('00016-do_RenameConcludedToActive.sql', &1, :v_pk);
 5END;
 6/
 7
 8---- ddl below ------------------------------------------
 9ALTER TABLE hippo.experiments DROP (concluded);
10ALTER TABLE hippo.experiments ADD (active NUMBER(1) NOT NULL);
11---------------------------------------------------------
12
13BEGIN
14    hippo.sp_update_version(16);
15    hippo.sp_log_version_change_finish(:v_pk, 'success');
16EXCEPTION
17    WHEN OTHERS THEN
18        hippo.sp_log_version_change_finish(:v_pk, 'fail');
19END;
20/