{"id":241,"date":"2012-03-02T04:26:10","date_gmt":"2012-03-02T04:26:10","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=241"},"modified":"2012-03-02T04:27:37","modified_gmt":"2012-03-02T04:27:37","slug":"invalid-object-summary","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=241","title":{"rendered":"Invalid object summary"},"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<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE  145<br \/>\nSET PAGESIZE  9999<\/p>\n<p>clear columns<br \/>\nclear breaks<br \/>\nclear computes<\/p>\n<p>column owner           format a25         heading 'Owner'<br \/>\ncolumn object_name     format a30         heading 'Object Name'<br \/>\ncolumn object_type     format a20         heading 'Object Type'<br \/>\ncolumn count           format 999,999     heading 'Count'<\/p>\n<p>break on owner skip 2 on report<br \/>\ncompute sum   label \"Count: \"        of count on owner<br \/>\ncompute sum   label \"Grand Total: \"  of count on report<\/p>\n<p>SELECT<br \/>\n    owner<br \/>\n  , object_type<br \/>\n  , count(*) Count<br \/>\nFROM dba_objects<br \/>\nWHERE status <> 'VALID'<br \/>\nGROUP BY owner, object_type<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<pre class=\"qcode\">\r\nSET LINESIZE  145\r\nSET PAGESIZE  9999\r\n\r\nclear columns\r\nclear breaks\r\nclear computes\r\n\r\ncolumn owner           format a25         heading 'Owner'\r\ncolumn object_name     format a30         heading 'Object Name'\r\ncolumn object_type     format a20         heading 'Object Type'\r\ncolumn count           format 999,999     heading 'Count'\r\n\r\nbreak on owner skip 2 on report\r\ncompute sum   label \"Count: \"        of count on owner\r\ncompute sum   label \"Grand Total: \"  of count on report\r\n\r\nSELECT\r\n    owner\r\n  , object_type\r\n  , count(*) Count\r\nFROM dba_objects\r\nWHERE status <> 'VALID'\r\nGROUP BY owner, object_type\r\n\/\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SET LINESIZE 145 SET PAGESIZE 9999 clear columns clear breaks clear computes column owner format a25 heading &#8216;Owner&#8217; column object_name format a30 heading &#8216;Object Name&#8217; column object_type format a20 heading &#8216;Object Type&#8217; column count format 999,999 heading &#8216;Count&#8217; break on owner skip 2 on report compute sum label &#8220;Count: &#8221; of count on owner compute [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":237,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-241","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-3T","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/241","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=241"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/241\/revisions"}],"predecessor-version":[{"id":245,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/241\/revisions\/245"}],"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=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}