{"id":293,"date":"2012-03-07T04:46:03","date_gmt":"2012-03-07T04:46:03","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=293"},"modified":"2012-03-07T04:46:47","modified_gmt":"2012-03-07T04:46:47","slug":"table-information","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=293","title":{"rendered":"Table information"},"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>\nGet information about one table in partucular schema<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nCOLUMN owner               FORMAT A15                HEADING \"Owner\"\r\nCOLUMN table_name          FORMAT A30                HEADING \"Table Name\"\r\nCOLUMN tablespace_name     FORMAT A28                HEADING \"Tablespace\"\r\nCOLUMN last_analyzed       FORMAT A20                HEADING \"Last Analyzed\"\r\nCOLUMN num_rows            FORMAT 999,999,999        HEADING \"# of Rows\"\r\n\r\nSELECT\r\n    owner\r\n  , table_name\r\n  , tablespace_name\r\n  , TO_CHAR(last_analyzed, 'DD-MON-YYYY HH24:MI:SS') last_analyzed\r\n  , num_rows\r\nFROM\r\n    dba_tables\r\nWHERE\r\n      owner      = UPPER('&schema_name')\r\n  AND table_name = UPPER('&table_name')\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nCOLUMN owner               FORMAT A15                HEADING \"Owner\"<br \/>\nCOLUMN table_name          FORMAT A30                HEADING \"Table Name\"<br \/>\nCOLUMN tablespace_name     FORMAT A28                HEADING \"Tablespace\"<br \/>\nCOLUMN last_analyzed       FORMAT A20                HEADING \"Last Analyzed\"<br \/>\nCOLUMN num_rows            FORMAT 999,999,999        HEADING \"# of Rows\"<\/p>\n<p>SELECT<br \/>\n    owner<br \/>\n  , table_name<br \/>\n  , tablespace_name<br \/>\n  , TO_CHAR(last_analyzed, 'DD-MON-YYYY HH24:MI:SS') last_analyzed<br \/>\n  , num_rows<br \/>\nFROM<br \/>\n    dba_tables<br \/>\nWHERE<br \/>\n      owner      = UPPER('&schema_name')<br \/>\n  AND table_name = UPPER('&table_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>Get information about one table in partucular schema COLUMN owner FORMAT A15 HEADING &#8220;Owner&#8221; COLUMN table_name FORMAT A30 HEADING &#8220;Table Name&#8221; COLUMN tablespace_name FORMAT A28 HEADING &#8220;Tablespace&#8221; COLUMN last_analyzed FORMAT A20 HEADING &#8220;Last Analyzed&#8221; COLUMN num_rows FORMAT 999,999,999 HEADING &#8220;# of Rows&#8221; SELECT owner , table_name , tablespace_name , TO_CHAR(last_analyzed, &#8216;DD-MON-YYYY HH24:MI:SS&#8217;) last_analyzed , num_rows [&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-293","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-4J","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/293","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=293"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/293\/revisions"}],"predecessor-version":[{"id":296,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/293\/revisions\/296"}],"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=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}