{"id":3204,"date":"2010-12-01T10:38:46","date_gmt":"2010-12-01T10:38:46","guid":{"rendered":"http:\/\/www.istratech.hr\/?p=3204"},"modified":"2021-07-23T12:04:54","modified_gmt":"2021-07-23T12:04:54","slug":"how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks","status":"publish","type":"post","link":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/","title":{"rendered":"How to write Oracle PL \/ SQL programs resistant to SQL injection attacks"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\" style=\"text-align:center\"><strong>ABSTRACT<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL injection is a code injection technique that exploits a security vulnerability occurring in the database. Dynamically generated SQL statements are semantically changed by the attacker who adds code. The paper describes how, by following Oracle recommendations, we can write PL\/SQL code that is resistant to SQL injection attacks.<\/p>\n\n\n<div class=\"more\"><a href=\"http:\/\/www.istratech.hr\/wp-content\/uploads\/2010\/12\/kom2010.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">VIEW LECTURE<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>ABSTRACT SQL injection is a code injection technique that exploits a security vulnerability occurring in the database. Dynamically generated SQL statements are semantically changed by the attacker who adds code. The paper describes how, by following Oracle recommendations, we can write PL\/SQL code that is resistant to SQL injection attacks.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_themeisle_gutenberg_block_has_review":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[172,330],"tags":[],"class_list":["post-3204","post","type-post","status-publish","format-standard","hentry","category-blog-en","category-conferences"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to write Oracle PL \/ SQL programs resistant to SQL injection attacks &#8211; Istra Tech<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to write Oracle PL \/ SQL programs resistant to SQL injection attacks &#8211; Istra Tech\" \/>\n<meta property=\"og:description\" content=\"ABSTRACT SQL injection is a code injection technique that exploits a security vulnerability occurring in the database. Dynamically generated SQL statements are semantically changed by the attacker who adds code. The paper describes how, by following Oracle recommendations, we can write PL\/SQL code that is resistant to SQL injection attacks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/\" \/>\n<meta property=\"og:site_name\" content=\"Istra Tech\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-01T10:38:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-23T12:04:54+00:00\" \/>\n<meta name=\"author\" content=\"Istratech Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Istratech Admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/\"},\"author\":{\"name\":\"Istratech Admin\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"headline\":\"How to write Oracle PL \\\/ SQL programs resistant to SQL injection attacks\",\"datePublished\":\"2010-12-01T10:38:46+00:00\",\"dateModified\":\"2021-07-23T12:04:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/\"},\"wordCount\":67,\"commentCount\":0,\"articleSection\":[\"Blog\",\"Conferences\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/\",\"name\":\"How to write Oracle PL \\\/ SQL programs resistant to SQL injection attacks &#8211; Istra Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\"},\"datePublished\":\"2010-12-01T10:38:46+00:00\",\"dateModified\":\"2021-07-23T12:04:54+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Po\u010detna stranica\",\"item\":\"https:\\\/\\\/www.istratech.hr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to write Oracle PL \\\/ SQL programs resistant to SQL injection attacks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/\",\"name\":\"Istra Tech\",\"description\":\"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/#\\\/schema\\\/person\\\/e56f98c854e5f471a7f577bd59ad397d\",\"name\":\"Istratech Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g\",\"caption\":\"Istratech Admin\"},\"url\":\"https:\\\/\\\/www.istratech.hr\\\/en\\\/author\\\/istratech_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to write Oracle PL \/ SQL programs resistant to SQL injection attacks &#8211; Istra Tech","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/","og_locale":"en_US","og_type":"article","og_title":"How to write Oracle PL \/ SQL programs resistant to SQL injection attacks &#8211; Istra Tech","og_description":"ABSTRACT SQL injection is a code injection technique that exploits a security vulnerability occurring in the database. Dynamically generated SQL statements are semantically changed by the attacker who adds code. The paper describes how, by following Oracle recommendations, we can write PL\/SQL code that is resistant to SQL injection attacks.","og_url":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/","og_site_name":"Istra Tech","article_published_time":"2010-12-01T10:38:46+00:00","article_modified_time":"2021-07-23T12:04:54+00:00","author":"Istratech Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Istratech Admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/#article","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/"},"author":{"name":"Istratech Admin","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"headline":"How to write Oracle PL \/ SQL programs resistant to SQL injection attacks","datePublished":"2010-12-01T10:38:46+00:00","dateModified":"2021-07-23T12:04:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/"},"wordCount":67,"commentCount":0,"articleSection":["Blog","Conferences"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/","url":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/","name":"How to write Oracle PL \/ SQL programs resistant to SQL injection attacks &#8211; Istra Tech","isPartOf":{"@id":"https:\/\/www.istratech.hr\/en\/#website"},"datePublished":"2010-12-01T10:38:46+00:00","dateModified":"2021-07-23T12:04:54+00:00","author":{"@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d"},"breadcrumb":{"@id":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.istratech.hr\/en\/how-to-write-oracle-pl-sql-programs-resistant-to-sql-injection-attacks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Po\u010detna stranica","item":"https:\/\/www.istratech.hr\/"},{"@type":"ListItem","position":2,"name":"How to write Oracle PL \/ SQL programs resistant to SQL injection attacks"}]},{"@type":"WebSite","@id":"https:\/\/www.istratech.hr\/en\/#website","url":"https:\/\/www.istratech.hr\/en\/","name":"Istra Tech","description":"Digitalizacija sustava u turizmu, hotelijerstvu i ugostiteljstvu","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.istratech.hr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.istratech.hr\/en\/#\/schema\/person\/e56f98c854e5f471a7f577bd59ad397d","name":"Istratech Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/08879edf0fbdb4c56d3bb4908200f600e0bcbb50c215e720817e00946f6b4822?s=96&d=mm&r=g","caption":"Istratech Admin"},"url":"https:\/\/www.istratech.hr\/en\/author\/istratech_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/comments?post=3204"}],"version-history":[{"count":0,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/posts\/3204\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/media?parent=3204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/categories?post=3204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.istratech.hr\/en\/wp-json\/wp\/v2\/tags?post=3204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}