{"id":363,"date":"2012-09-03T02:27:24","date_gmt":"2012-09-03T02:27:24","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=363"},"modified":"2012-09-03T04:49:00","modified_gmt":"2012-09-03T04:49:00","slug":"object-info","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=363","title":{"rendered":"Objects info"},"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 object info<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 135\r\nSET PAGESIZE 9999\r\n\r\nCOLUMN owner           FORMAT A15    HEADING \"Owner\"\r\nCOLUMN object_name     FORMAT A35    HEADING \"Object Name\"\r\nCOLUMN object_type     FORMAT A18    HEADING \"Object Type\"\r\nCOLUMN created                       HEADING \"Created\"\r\nCOLUMN status                        HEADING \"Status\"\r\n\r\nSELECT\r\n    owner\r\n  , object_name\r\n  , object_type\r\n  , TO_CHAR(created, 'DD-MON-YYYY HH24:MI:SS') created\r\n  , LPAD(status, 7) status\r\nFROM all_objects\r\nWHERE object_name like UPPER('%&OBJECT_NAME%')\r\nORDER BY owner, object_name, object_type\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 135<br \/>\nSET PAGESIZE 9999<\/p>\n<p>COLUMN owner           FORMAT A15    HEADING \"Owner\"<br \/>\nCOLUMN object_name     FORMAT A35    HEADING \"Object Name\"<br \/>\nCOLUMN object_type     FORMAT A18    HEADING \"Object Type\"<br \/>\nCOLUMN created                       HEADING \"Created\"<br \/>\nCOLUMN status                        HEADING \"Status\"<\/p>\n<p>SELECT<br \/>\n    owner<br \/>\n  , object_name<br \/>\n  , object_type<br \/>\n  , TO_CHAR(created, 'DD-MON-YYYY HH24:MI:SS') created<br \/>\n  , LPAD(status, 7) status<br \/>\nFROM all_objects<br \/>\nWHERE object_name like UPPER('%&OBJECT_NAME%')<br \/>\nORDER BY owner, object_name, object_type<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<h2>\nObjects summary<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 135\r\nSET PAGESIZE 9999\r\n\r\nCOLUMN owner           FORMAT A15          HEADING \"Owner\"\r\nCOLUMN object_type     FORMAT A18          HEADING \"Object Type\"\r\nCOLUMN obj_count       FORMAT 999,999,999  HEADING \"Object Count\"\r\n\r\nbreak on report on owner skip 2\r\ncompute sum label \"\"               of obj_count on owner\r\ncompute sum label \"Grand Total: \"  of obj_count on report\r\n\r\nSELECT\r\n    owner\r\n  , object_type\r\n  , count(*)    obj_count\r\nFROM\r\n    dba_objects\r\nGROUP BY\r\n    owner\r\n  , object_type\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 135<br \/>\nSET PAGESIZE 9999<\/p>\n<p>COLUMN owner           FORMAT A15          HEADING \"Owner\"<br \/>\nCOLUMN object_type     FORMAT A18          HEADING \"Object Type\"<br \/>\nCOLUMN obj_count       FORMAT 999,999,999  HEADING \"Object Count\"<\/p>\n<p>break on report on owner skip 2<br \/>\ncompute sum label \"\"               of obj_count on owner<br \/>\ncompute sum label \"Grand Total: \"  of obj_count on report<\/p>\n<p>SELECT<br \/>\n    owner<br \/>\n  , object_type<br \/>\n  , count(*)    obj_count<br \/>\nFROM<br \/>\n    dba_objects<br \/>\nGROUP BY<br \/>\n    owner<br \/>\n  , object_type<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 object info SET LINESIZE 135 SET PAGESIZE 9999 COLUMN owner FORMAT A15 HEADING &#8220;Owner&#8221; COLUMN object_name FORMAT A35 HEADING &#8220;Object Name&#8221; COLUMN object_type FORMAT A18 HEADING &#8220;Object Type&#8221; COLUMN created HEADING &#8220;Created&#8221; COLUMN status HEADING &#8220;Status&#8221; SELECT owner , object_name , object_type , TO_CHAR(created, &#8216;DD-MON-YYYY HH24:MI:SS&#8217;) created , LPAD(status, 7) status FROM all_objects WHERE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":237,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-363","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5R","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/363","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=363"}],"version-history":[{"count":5,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/363\/revisions"}],"predecessor-version":[{"id":380,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/363\/revisions\/380"}],"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=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}