{"id":370,"date":"2012-09-03T02:33:29","date_gmt":"2012-09-03T02:33:29","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=370"},"modified":"2015-06-19T04:33:57","modified_gmt":"2015-06-19T04:33:57","slug":"hidden-parameters","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=370","title":{"rendered":"DB parameters"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<h2>\nShow hidden parameters<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 145\r\nSET PAGESIZE 9999\r\nSET VERIFY   off\r\n\r\nCOLUMN ksppinm   FORMAT A42   HEAD 'Parameter Name'\r\nCOLUMN ksppstvl  FORMAT A39   HEAD 'Value'\r\nCOLUMN ksppdesc  FORMAT A60   HEAD 'Description'    TRUNC\r\n\r\n\r\nSELECT\r\n    ksppinm\r\n  , ksppstvl\r\n  , ksppdesc\r\nFROM\r\n    x$ksppi x\r\n  , x$ksppcv y\r\nWHERE\r\n      x.indx = y.indx \r\n  AND TRANSLATE(ksppinm,'_','#') like '#%'\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 145<br \/>\nSET PAGESIZE 9999<br \/>\nSET VERIFY   off<\/p>\n<p>COLUMN ksppinm   FORMAT A42   HEAD 'Parameter Name'<br \/>\nCOLUMN ksppstvl  FORMAT A39   HEAD 'Value'<br \/>\nCOLUMN ksppdesc  FORMAT A60   HEAD 'Description'    TRUNC<\/p>\n<p>SELECT<br \/>\n    ksppinm<br \/>\n  , ksppstvl<br \/>\n  , ksppdesc<br \/>\nFROM<br \/>\n    x$ksppi x<br \/>\n  , x$ksppcv y<br \/>\nWHERE<br \/>\n      x.indx = y.indx<br \/>\n  AND TRANSLATE(ksppinm,'_','#') like '#%'<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<h2>\nGet 1 hidden parameter<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nselect a.ksppinm name, b.ksppstvl value,\r\nb.ksppstdf deflt, decode\r\n(a.ksppity, 1,\r\n'boolean', 2,\r\n'string', 3,\r\n'number', 4,\r\n'file', a.ksppity) type,\r\na.ksppdesc description\r\nfrom sys.x$ksppi a, sys.x$ksppcv b\r\nwhere a.indx = b.indx and\r\na.ksppinm like '\\_%' escape '\\'\r\nand a.ksppinm like UPPER('%&PARAM_NAME%')\r\norder by name;\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nselect a.ksppinm name, b.ksppstvl value,<br \/>\nb.ksppstdf deflt, decode<br \/>\n(a.ksppity, 1,<br \/>\n'boolean', 2,<br \/>\n'string', 3,<br \/>\n'number', 4,<br \/>\n'file', a.ksppity) type,<br \/>\na.ksppdesc description<br \/>\nfrom sys.x$ksppi a, sys.x$ksppcv b<br \/>\nwhere a.indx = b.indx and<br \/>\na.ksppinm like '\\_%' escape '\\'<br \/>\nand a.ksppinm like UPPER('%&PARAM_NAME%')<br \/>\norder by name;<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<h2>\nDB parameter<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nset linesize 230\r\nset pagesize 9999\r\nCOLUMN name      \t\tFORMAT a40\t\t  HEADING 'Name'\r\nCOLUMN value       \t\tFORMAT a80\t\t  HEADING 'Value'\r\nCOLUMN display_value\tFORMAT a30\t\t  HEADING 'Display Value'\r\n\r\nselect name, value, display_value, ISDEFAULT, ISMODIFIED, ISSES_MODIFIABLE, ISSYS_MODIFIABLE, ISADJUSTED from v$parameter \r\n\twhere upper(name) like upper('%&PARAM_NAME%')\r\n\torder by name\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nset linesize 230<br \/>\nset pagesize 9999<br \/>\nCOLUMN name      \t\tFORMAT a40\t\t  HEADING 'Name'<br \/>\nCOLUMN value       \t\tFORMAT a80\t\t  HEADING 'Value'<br \/>\nCOLUMN display_value\tFORMAT a30\t\t  HEADING 'Display Value'<\/p>\n<p>select name, value, display_value, ISDEFAULT, ISMODIFIED, ISSES_MODIFIABLE, ISSYS_MODIFIABLE, ISADJUSTED from v$parameter<br \/>\n\twhere upper(name) like upper('%&PARAM_NAME%')<br \/>\n\torder by name<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Show hidden parameters SET LINESIZE 145 SET PAGESIZE 9999 SET VERIFY off COLUMN ksppinm FORMAT A42 HEAD &#8216;Parameter Name&#8217; COLUMN ksppstvl FORMAT A39 HEAD &#8216;Value&#8217; COLUMN ksppdesc FORMAT A60 HEAD &#8216;Description&#8217; TRUNC SELECT ksppinm , ksppstvl , ksppdesc FROM x$ksppi x , x$ksppcv y WHERE x.indx = y.indx AND TRANSLATE(ksppinm,&#8217;_&#8217;,&#8217;#&#8217;) like &#8216;#%&#8217; \/ SET LINESIZE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":368,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-370","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5Y","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=370"}],"version-history":[{"count":3,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/370\/revisions"}],"predecessor-version":[{"id":546,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/370\/revisions\/546"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/368"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}