{"id":11262,"date":"2024-03-14T13:42:36","date_gmt":"2024-03-14T13:42:36","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/"},"modified":"2025-08-04T09:35:05","modified_gmt":"2025-08-04T09:35:05","slug":"how-do-you-use-execute-immediate-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/","title":{"rendered":"EXECUTE IMMEDIATE in Oracle: Usage Guide"},"content":{"rendered":"<p>The EXECUTE IMMEDIATE statement is used in PL\/SQL programs to dynamically execute SQL statements. Here is an example of using EXECUTE IMMEDIATE:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">DECLARE<\/span>\r\n  sql_stmt VARCHAR2(<span class=\"hljs-number\">200<\/span>);\r\n  emp_name VARCHAR2(<span class=\"hljs-number\">100<\/span>);\r\n<span class=\"hljs-keyword\">BEGIN<\/span>\r\n  sql_stmt :<span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'SELECT ename FROM emp WHERE empno = 7839'<\/span>;\r\n  <span class=\"hljs-keyword\">EXECUTE<\/span> IMMEDIATE sql_stmt <span class=\"hljs-keyword\">INTO<\/span> emp_name;\r\n  DBMS_OUTPUT.PUT_LINE(<span class=\"hljs-string\">'Employee name is: '<\/span> <span class=\"hljs-operator\">||<\/span> emp_name);\r\n<span class=\"hljs-keyword\">END<\/span>;\r\n<\/code><\/pre>\n<p>In this example, we begin by declaring a variable called sql_stmt to store the SQL statement to be executed. Next, we use the EXECUTE IMMEDIATE statement to execute the SELECT statement and store the result in the emp_name variable. Finally, we use the DBMS_OUTPUT.PUT_LINE statement to print out the employee name retrieved from the database.<\/p>\n<p>It&#8217;s important to be cautious when using EXECUTE IMMEDIATE to execute dynamic SQL statements, as care must be taken to prevent SQL injection attacks. One way to avoid this is by using bind variables.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The EXECUTE IMMEDIATE statement is used in PL\/SQL programs to dynamically execute SQL statements. Here is an example of using EXECUTE IMMEDIATE: DECLARE sql_stmt VARCHAR2(200); emp_name VARCHAR2(100); BEGIN sql_stmt := &#8216;SELECT ename FROM emp WHERE empno = 7839&#8217;; EXECUTE IMMEDIATE sql_stmt INTO emp_name; DBMS_OUTPUT.PUT_LINE(&#8216;Employee name is: &#8216; || emp_name); END; In this example, we begin [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[1467,14459,813,3302,14460],"class_list":["post-11262","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-dynamic-sql","tag-execute-immediate","tag-oracle-database","tag-oracle-pl-sql","tag-pl-sql-examples"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EXECUTE IMMEDIATE in Oracle: Usage Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to use EXECUTE IMMEDIATE for dynamic SQL in Oracle PL\/SQL, with practical examples and syntax.\" \/>\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.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXECUTE IMMEDIATE in Oracle: Usage Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to use EXECUTE IMMEDIATE for dynamic SQL in Oracle PL\/SQL, with practical examples and syntax.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T13:42:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T09:35:05+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"EXECUTE IMMEDIATE in Oracle: Usage Guide\",\"datePublished\":\"2024-03-14T13:42:36+00:00\",\"dateModified\":\"2025-08-04T09:35:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/\"},\"wordCount\":124,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"dynamic SQL\",\"execute immediate\",\"Oracle database\",\"Oracle PL\/SQL\",\"PL\/SQL examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/\",\"name\":\"EXECUTE IMMEDIATE in Oracle: Usage Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T13:42:36+00:00\",\"dateModified\":\"2025-08-04T09:35:05+00:00\",\"description\":\"Learn how to use EXECUTE IMMEDIATE for dynamic SQL in Oracle PL\/SQL, with practical examples and syntax.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EXECUTE IMMEDIATE in Oracle: Usage Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"EXECUTE IMMEDIATE in Oracle: Usage Guide - Blog - Silicon Cloud","description":"Learn how to use EXECUTE IMMEDIATE for dynamic SQL in Oracle PL\/SQL, with practical examples and syntax.","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.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"EXECUTE IMMEDIATE in Oracle: Usage Guide","og_description":"Learn how to use EXECUTE IMMEDIATE for dynamic SQL in Oracle PL\/SQL, with practical examples and syntax.","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T13:42:36+00:00","article_modified_time":"2025-08-04T09:35:05+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"EXECUTE IMMEDIATE in Oracle: Usage Guide","datePublished":"2024-03-14T13:42:36+00:00","dateModified":"2025-08-04T09:35:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/"},"wordCount":124,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["dynamic SQL","execute immediate","Oracle database","Oracle PL\/SQL","PL\/SQL examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/","name":"EXECUTE IMMEDIATE in Oracle: Usage Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T13:42:36+00:00","dateModified":"2025-08-04T09:35:05+00:00","description":"Learn how to use EXECUTE IMMEDIATE for dynamic SQL in Oracle PL\/SQL, with practical examples and syntax.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-execute-immediate-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"EXECUTE IMMEDIATE in Oracle: Usage Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=11262"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11262\/revisions"}],"predecessor-version":[{"id":155034,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11262\/revisions\/155034"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=11262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=11262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=11262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}