{"id":545,"date":"2023-03-29T14:14:07","date_gmt":"2023-03-29T12:14:07","guid":{"rendered":"https:\/\/anjo.pt\/keyword-oracle\/?p=545"},"modified":"2023-03-29T14:23:08","modified_gmt":"2023-03-29T12:23:08","slug":"can-chatgpt-steal-our-oracle-dba-job","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2023\/03\/29\/can-chatgpt-steal-our-oracle-dba-job\/","title":{"rendered":"Can ChatGPT steal our (Oracle DBA) job?"},"content":{"rendered":"\n<p>I would not say it will steal our job, but it can facilitate in some cases to write small pieces of code without having much to think. Well, help first to be lazy, before getting our job. Last example today:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"674\" src=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-1.png\" alt=\"\" class=\"wp-image-546\" srcset=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-1.png 796w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-1-300x254.png 300w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-1-768x650.png 768w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/a><figcaption class=\"wp-element-caption\">Request ChatGPT to write a trigger that enables BCT after the database opens. <\/figcaption><\/figure>\n\n\n\n<p>The power is amazing. After looking at the result, you think about a small detail, ask again and it just answers:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"803\" height=\"888\" src=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-2.png\" alt=\"\" class=\"wp-image-547\" srcset=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-2.png 803w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-2-271x300.png 271w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2023\/03\/image-2-768x849.png 768w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/a><figcaption class=\"wp-element-caption\">Ask ChatGPT to improve so it triggers only when a switchover happened.<\/figcaption><\/figure>\n\n\n\n<p>But one must always test carefully the answers. Like this case, where the EVENT_TYPE column does not exist on V$DATAGUARD_STATUS table. No idea how he discovers it. I also got non existing syntax and complex solutions that could be easily made simpler.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I would not say it will steal our job, but it can facilitate in some cases to write small pieces of code without having much to think. Well, help first to be lazy, before getting our job. Last example today: The power is amazing. After looking at the result, you think about a small detail, [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,21,6],"tags":[],"class_list":{"0":"post-545","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-dataguard","7":"category-ideas","8":"category-oracle","9":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=545"}],"version-history":[{"count":2,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/545\/revisions"}],"predecessor-version":[{"id":550,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/545\/revisions\/550"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}