{"id":15,"date":"2014-02-03T04:48:00","date_gmt":"2014-02-03T04:48:00","guid":{"rendered":"https:\/\/sanmaharjan.com\/2014\/02\/03\/mail-client-in-oracle-database\/"},"modified":"2014-02-03T12:50:57","modified_gmt":"2014-02-03T12:50:57","slug":"mail-client-in-oracle-database","status":"publish","type":"post","link":"https:\/\/sanmaharjan.com\/mail-client-in-oracle-database\/","title":{"rendered":"Mail Client in Oracle Database"},"content":{"rendered":"<div dir=\"ltr\">Yes you can receive Mail and send in Oracle Database and store into Database or manipulate email to do some task.<br \/>\nI m always lazy to do some repetative task In my Work i was always ask to do send status of certain task from Database and send to back to them via mail. for a beginning it is fun. but when the request number is increasing it is getting boring and monotonous. so what i did is i installed <a href=\"http:\/\/plsqlmailclient.sourceforge.net\/\">Mail client <\/a>in one the schema in my Database which reads emails. then i scheduled the job which reads subject of emails that has keyword [Status] and followed by Report Name. so the scheduler reads and do query and generate report in clob and sends the output to sender Mail.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Yes you can receive Mail and send in Oracle Database and store into Database or manipulate email to do some task. I m always lazy to do some repetative task In my Work i was always ask to do send status of certain task from Database and send to back to them via mail. for [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31],"tags":[34,10,12,11],"_links":{"self":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/15"}],"collection":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":2,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"predecessor-version":[{"id":32,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/15\/revisions\/32"}],"wp:attachment":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}