{"id":7,"date":"2006-03-24T08:23:00","date_gmt":"2006-03-24T14:23:00","guid":{"rendered":"http:\/\/bakore.info\/?p=7"},"modified":"2008-08-02T02:48:17","modified_gmt":"2008-08-02T02:48:17","slug":"during-the-course-of-writing-the-htmldb-oracle-ap","status":"publish","type":"post","link":"http:\/\/degenio.com\/blog\/2006\/03\/during-the-course-of-writing-the-htmldb-oracle-ap\/","title":{"rendered":"During the course of writing the HTMLDB (oracle ap&#8230;"},"content":{"rendered":"<p>During the course of writing the HTMLDB (oracle applications express-APEX- a.k.a TAKFAH) tutorial, I was confronted to the case of the POST-CHANGE trigger (Forms-like) in APEX.<\/p>\n<p>The question was already asked by a user on OTN and I went through an implementation using an idea borrowed from Carl Backstrom.<\/p>\n<p>Here is the problem: you create a report  based on one table. However, in one of the region, you want to retrieve the details based on one of the items from another table.<\/p>\n<p>Here is the link: <a href=\"http:\/\/forums.oracle.com\/forums\/thread.jspa?messageID=1234011?\">http:\/\/forums.oracle.com\/forums\/thread.jspa?messageID=1234011?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>During the course of writing the HTMLDB (oracle applications express-APEX- a.k.a TAKFAH) tutorial, I was confronted to the case of the POST-CHANGE trigger (Forms-like) in APEX. The question was already asked by a user on OTN and I went through an implementation using an idea borrowed from Carl Backstrom. Here is the problem: you create [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[6,1],"tags":[],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/phEMW-7","_links":{"self":[{"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts\/7"}],"collection":[{"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":0,"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts\/7\/revisions"}],"wp:attachment":[{"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/media?parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/categories?post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/tags?post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}