{"id":239,"date":"2012-03-02T04:25:22","date_gmt":"2012-03-02T04:25:22","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=239"},"modified":"2012-03-02T04:27:27","modified_gmt":"2012-03-02T04:27:27","slug":"invalid-objects","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=239","title":{"rendered":"Invalid 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<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 status          format a10         heading 'Status'<\/p>\n<p>break on owner skip 2 on report<br \/>\ncompute count label \"\"               of object_name on owner<br \/>\ncompute count label \"Grand Total: \"  of object_name on report<\/p>\n<p>SELECT<br \/>\n    owner<br \/>\n  , object_name<br \/>\n  , object_type<br \/>\n  , status<br \/>\nFROM dba_objects<br \/>\nWHERE status <> 'VALID'<br \/>\nORDER BY owner, object_name<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 status          format a10         heading 'Status'\r\n\r\nbreak on owner skip 2 on report\r\ncompute count label \"\"               of object_name on owner\r\ncompute count label \"Grand Total: \"  of object_name on report\r\n\r\nSELECT\r\n    owner\r\n  , object_name\r\n  , object_type\r\n  , status\r\nFROM dba_objects\r\nWHERE status <> 'VALID'\r\nORDER BY owner, object_name\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 status format a10 heading &#8216;Status&#8217; break on owner skip 2 on report compute count label &#8220;&#8221; of object_name on owner compute count [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":237,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-239","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-3R","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/239","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=239"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/239\/revisions"}],"predecessor-version":[{"id":244,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/239\/revisions\/244"}],"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=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}