{"id":313,"date":"2012-03-07T23:15:19","date_gmt":"2012-03-07T23:15:19","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=313"},"modified":"2012-03-07T23:15:19","modified_gmt":"2012-03-07T23:15:19","slug":"triggers","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=313","title":{"rendered":"Triggers"},"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 triggers<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nCOLUMN trigger_name            FORMAT A25                HEADING \"Trigger Name\"\r\nCOLUMN trigger_type            FORMAT A18                HEADING \"Type\"\r\nCOLUMN triggering_event        FORMAT A9                 HEADING \"Trig.|Event\"\r\nCOLUMN referencing_names       FORMAT A65                HEADING \"Referencing Names\" newline\r\nCOLUMN when_clause             FORMAT A65                HEADING \"When Clause\" newline\r\nCOLUMN trigger_body            FORMAT A65                HEADING \"Trigger Body\" newline\r\n\r\nSELECT\r\n    owner || '.' || trigger_name  trigger_name\r\n  , trigger_type\r\n  , triggering_event\r\n  , status\r\n  , referencing_names\r\n  , when_clause\r\n  , trigger_body\r\nFROM\r\n    dba_triggers\r\nWHERE\r\n      table_owner = UPPER('&schema_name')\r\n  AND table_name  = UPPER('&table_name')\r\nORDER BY\r\n     trigger_name\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nCOLUMN trigger_name            FORMAT A25                HEADING \"Trigger Name\"<br \/>\nCOLUMN trigger_type            FORMAT A18                HEADING \"Type\"<br \/>\nCOLUMN triggering_event        FORMAT A9                 HEADING \"Trig.|Event\"<br \/>\nCOLUMN referencing_names       FORMAT A65                HEADING \"Referencing Names\" newline<br \/>\nCOLUMN when_clause             FORMAT A65                HEADING \"When Clause\" newline<br \/>\nCOLUMN trigger_body            FORMAT A65                HEADING \"Trigger Body\" newline<\/p>\n<p>SELECT<br \/>\n    owner || '.' || trigger_name  trigger_name<br \/>\n  , trigger_type<br \/>\n  , triggering_event<br \/>\n  , status<br \/>\n  , referencing_names<br \/>\n  , when_clause<br \/>\n  , trigger_body<br \/>\nFROM<br \/>\n    dba_triggers<br \/>\nWHERE<br \/>\n      table_owner = UPPER('&schema_name')<br \/>\n  AND table_name  = UPPER('&table_name')<br \/>\nORDER BY<br \/>\n     trigger_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>Table triggers COLUMN trigger_name FORMAT A25 HEADING &#8220;Trigger Name&#8221; COLUMN trigger_type FORMAT A18 HEADING &#8220;Type&#8221; COLUMN triggering_event FORMAT A9 HEADING &#8220;Trig.|Event&#8221; COLUMN referencing_names FORMAT A65 HEADING &#8220;Referencing Names&#8221; newline COLUMN when_clause FORMAT A65 HEADING &#8220;When Clause&#8221; newline COLUMN trigger_body FORMAT A65 HEADING &#8220;Trigger Body&#8221; newline SELECT owner || &#8216;.&#8217; || trigger_name trigger_name , trigger_type , [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":291,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-313","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-53","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/313","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=313"}],"version-history":[{"count":1,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/313\/revisions"}],"predecessor-version":[{"id":314,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/313\/revisions\/314"}],"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=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}