/
getplusparm.sql
40 lines (32 loc) · 1.1 KB
/
getplusparm.sql
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
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
--------------------------------------------------------------------------------
--
-- File name: getplusparm.sql
-- Purpose: get sqlplus parameter value (such linesize, pagesize, sqlcode,
-- etc) into a sqlplus define variable
--
-- Author: Tanel Poder
-- Copyright: (c) http://www.tanelpoder.com
--
-- Usage: @getplusparm [full-param-name] [def-variable-name]
--
-- Example: @getplusparm linesize sqlplus_line_size
-- def sqlplus_line_size
--
--------------------------------------------------------------------------------
@saveset
set termout off
spool &SQLPATH/tmp/getplusparm.tmp
show &1
spool off
spool &SQLPATH/tmp/chgplusparm.tmp
prompt c/&1/def &2/
prompt c/&2 /&2=/
spool off
get &SQLPATH/tmp/getplusparm.tmp nolist
@&SQLPATH/tmp/chgplusparm.tmp
save file &SQLPATH/tmp/setplusparm.tmp replace
@&SQLPATH/tmp/setplusparm.tmp
@loadset
unset _getplusparm_tmpfile