-
Notifications
You must be signed in to change notification settings - Fork 187
Expand file tree
/
Copy pathut_i_do.sql
More file actions
75 lines (66 loc) · 2.57 KB
/
ut_i_do.sql
File metadata and controls
75 lines (66 loc) · 2.57 KB
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
CLEAR SCREEN
SET TERMOUT OFF
SET ECHO OFF
SET VERIFY OFF
SET FEEDBACK OFF
SET TTITLE OFF
SET SERVEROUTPUT ON SIZE 1000000 FORMAT WRAPPED
SET DEFINE ON
----------------------------------------------------
-- ou installator
--
-- parameter 1 values:
--
-- install - UT full installation
-- recompile - Recompile UT code base
-- synonyms - Create public synonyms for UT
-- uninstall - Deinstall UT
----------------------------------------------------
DEFINE line1='-------------------------------------------------------------'
DEFINE line2='============================================================='
DEFINE finished='. Finished'
DEFINE UT='utPLSQL'
COLUMN col NOPRINT NEW_VALUE ut_owner
select USER col from dual;
COLUMN col NOPRINT NEW_VALUE next_script
select decode(LOWER('&1'),'install','ut_i_install',
'recompile','ut_i_recompile',
'compile','ut_i_recompile',
'synonyms','ut_i_synonyms',
'synonym','ut_i_synonyms',
'uninstall','ut_i_uninstall',
'deinstall','ut_i_uninstall',
'ERROR') col from dual;
COLUMN col NOPRINT NEW_VALUE txt_prompt
select decode('&next_script','ut_i_install','I N S T A L L A T I O N',
'ut_i_recompile','R E C O M P I L A T I O N',
'ut_i_synonyms','S Y N O N Y M S',
'ut_i_uninstall','D E I N S T A L L A T I O N',
'ERROR') col from dual;
------------------------------------------------------
SET TERMOUT ON
PROMPT &line2
PROMPT GNU General Public License for utPLSQL
PROMPT
PROMPT Copyright (C) 2000-2003
PROMPT Steven Feuerstein and the utPLSQL Project
PROMPT (steven@stevenfeuerstein.com)
PROMPT
PROMPT This program is free software; you can redistribute it and/or modify
PROMPT it under the terms of the GNU General Public License as published by
PROMPT the Free Software Foundation; either version 2 of the License, or
PROMPT (at your option) any later version.
PROMPT
PROMPT This program is distributed in the hope that it will be useful,
PROMPT but WITHOUT ANY WARRANTY; without even the implied warranty of
PROMPT MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
PROMPT GNU General Public License for more details.
PROMPT
PROMPT You should have received a copy of the GNU General Public License
PROMPT along with this program (see license.txt); if not, write to the Free Software
PROMPT Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
PROMPT &line2
PROMPT
PROMPT [ &txt_prompt ]
@@ut_i_preprocess
@@&next_script