{"id":299,"date":"2012-03-07T04:56:39","date_gmt":"2012-03-07T04:56:39","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=299"},"modified":"2012-03-07T04:58:25","modified_gmt":"2012-03-07T04:58:25","slug":"columns","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=299","title":{"rendered":"Columns"},"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>\nTable columns<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nCOLUMN column_name         FORMAT A20                HEADING \"Column Name\"\r\nCOLUMN data_type           FORMAT A25                HEADING \"Data Type\"\r\nCOLUMN nullable            FORMAT A13                HEADing \"Null?\"\r\n\r\nSELECT\r\n    column_name\r\n  , DECODE(nullable, 'Y', ' ', 'NOT NULL') nullable\r\n  , DECODE(data_type\r\n               , 'RAW',      data_type || '(' ||  data_length || ')'\r\n               , 'CHAR',     data_type || '(' ||  data_length || ')'\r\n               , 'VARCHAR',  data_type || '(' ||  data_length || ')'\r\n               , 'VARCHAR2', data_type || '(' ||  data_length || ')'\r\n               , 'NUMBER', NVL2(   data_precision\r\n                                 , DECODE(    data_scale\r\n                                            , 0\r\n                                            , data_type || '(' || data_precision || ')'\r\n                                            , data_type || '(' || data_precision || ',' || data_scale || ')'\r\n                                   )\r\n                                 , data_type)\r\n               , data_type\r\n    ) data_type\r\nFROM\r\n    dba_tab_columns\r\nWHERE\r\n      owner      = UPPER('&schema_name')\r\n  AND table_name = UPPER('&table_name')\r\nORDER BY\r\n    column_id\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nCOLUMN column_name         FORMAT A20                HEADING \"Column Name\"<br \/>\nCOLUMN data_type           FORMAT A25                HEADING \"Data Type\"<br \/>\nCOLUMN nullable            FORMAT A13                HEADing \"Null?\"<\/p>\n<p>SELECT<br \/>\n    column_name<br \/>\n  , DECODE(nullable, 'Y', ' ', 'NOT NULL') nullable<br \/>\n  , DECODE(data_type<br \/>\n               , 'RAW',      data_type || '(' ||  data_length || ')'<br \/>\n               , 'CHAR',     data_type || '(' ||  data_length || ')'<br \/>\n               , 'VARCHAR',  data_type || '(' ||  data_length || ')'<br \/>\n               , 'VARCHAR2', data_type || '(' ||  data_length || ')'<br \/>\n               , 'NUMBER', NVL2(   data_precision<br \/>\n                                 , DECODE(    data_scale<br \/>\n                                            , 0<br \/>\n                                            , data_type || '(' || data_precision || ')'<br \/>\n                                            , data_type || '(' || data_precision || ',' || data_scale || ')'<br \/>\n                                   )<br \/>\n                                 , data_type)<br \/>\n               , data_type<br \/>\n    ) data_type<br \/>\nFROM<br \/>\n    dba_tab_columns<br \/>\nWHERE<br \/>\n      owner      = UPPER('&schema_name')<br \/>\n  AND table_name = UPPER('&table_name')<br \/>\nORDER BY<br \/>\n    column_id<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>Table columns COLUMN column_name FORMAT A20 HEADING &#8220;Column Name&#8221; COLUMN data_type FORMAT A25 HEADING &#8220;Data Type&#8221; COLUMN nullable FORMAT A13 HEADing &#8220;Null?&#8221; SELECT column_name , DECODE(nullable, &#8216;Y&#8217;, &#8216; &#8216;, &#8216;NOT NULL&#8217;) nullable , DECODE(data_type , &#8216;RAW&#8217;, data_type || &#8216;(&#8216; || data_length || &#8216;)&#8217; , &#8216;CHAR&#8217;, data_type || &#8216;(&#8216; || data_length || &#8216;)&#8217; , &#8216;VARCHAR&#8217;, data_type [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":291,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-299","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-4P","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/299","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=299"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/299\/revisions"}],"predecessor-version":[{"id":301,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/299\/revisions\/301"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/291"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}