{"id":398,"date":"2012-11-06T22:56:16","date_gmt":"2012-11-06T22:56:16","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=398"},"modified":"2016-06-03T04:54:13","modified_gmt":"2016-06-03T04:54:13","slug":"dictionary-objects","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=398","title":{"rendered":"Dictionary objects"},"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>\nFind the dictionary table<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nset linesize 200\r\nset verify off\r\nset pagesize 9999\r\n\r\nCOLUMN table_name      \tFORMAT a30            HEADING 'Table name'\r\nCOLUMN Comments   \t\tFORMAT a90            HEADING 'Comments'\r\n\r\nselect table_name, comments \r\n\tfrom dictionary \r\n\twhere table_name like upper('%&TABLE_TO_FIND%')\r\norder by table_name\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nset linesize 200<br \/>\nset verify off<br \/>\nset pagesize 9999<\/p>\n<p>COLUMN table_name      \tFORMAT a30            HEADING 'Table name'<br \/>\nCOLUMN Comments   \t\tFORMAT a90            HEADING 'Comments'<\/p>\n<p>select table_name, comments<br \/>\n\tfrom dictionary<br \/>\n\twhere table_name like upper('%&TABLE_TO_FIND%')<br \/>\norder by table_name<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<h2>\nFixed tables<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nset linesize 200\r\nset verify off\r\nset pagesize 9999\r\nselect name, type from v$fixed_table \r\n\twhere name like upper('%&TABLE_TO_FIND%')\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 200<br \/>\nset verify off<br \/>\nset pagesize 9999<br \/>\nselect name, type from v$fixed_table<br \/>\n\twhere name like upper('%&TABLE_TO_FIND%')<br \/>\n\torder by name<br \/>\n\/<\/p>\n<p><\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Find the dictionary table set linesize 200 set verify off set pagesize 9999 COLUMN table_name FORMAT a30 HEADING &#8216;Table name&#8217; COLUMN Comments FORMAT a90 HEADING &#8216;Comments&#8217; select table_name, comments from dictionary where table_name like upper(&#8216;%&#038;TABLE_TO_FIND%&#8217;) order by table_name \/ set linesize 200 set verify off set pagesize 9999 COLUMN table_name FORMAT a30 HEADING &#8216;Table name&#8217; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":237,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-398","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-6q","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/398","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=398"}],"version-history":[{"count":5,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/398\/revisions"}],"predecessor-version":[{"id":562,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/398\/revisions\/562"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/237"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}