{"id":15820,"date":"2024-03-15T11:47:47","date_gmt":"2024-03-15T11:47:47","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/"},"modified":"2025-08-06T21:49:55","modified_gmt":"2025-08-06T21:49:55","slug":"what-is-the-method-used-in-oracle-for-select-into","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/","title":{"rendered":"What is the method used in Oracle for &#8220;select into&#8221;?"},"content":{"rendered":"<p>In Oracle, you can use the SELECT INTO statement to store the results of a query into a variable or table.<\/p>\n<p>The syntax for storing query results into a variable using the SELECT INTO statement is as follows:<\/p>\n<pre class=\"post-pre\"><code>SELECT column_name INTO variable_name\r\nFROM table_name\r\nWHERE condition;\r\n<\/code><\/pre>\n<p>In the above syntax, column_name refers to the name of the column to be queried, variable_name is the name of the variable where the result will be stored, table_name is the name of the table to be queried, and condition represents the query condition.<\/p>\n<p>For example, the following example will query the employee table for employees with the last name &#8220;Smith&#8221; and store their names in a variable:<\/p>\n<pre class=\"post-pre\"><code>DECLARE\r\n  v_employee_name employees.last_name%TYPE;\r\nBEGIN\r\n  SELECT last_name INTO v_employee_name\r\n  FROM employees\r\n  WHERE last_name = 'Smith';\r\n  \r\n  DBMS_OUTPUT.PUT_LINE('Employee Name: ' || v_employee_name);\r\nEND;\r\n\/\r\n<\/code><\/pre>\n<p>In the example above, a variable v_employee_name is defined using the DECLARE statement, and then the SELECT INTO statement is used to store the query result in this variable. Finally, the result is output to the console using the DBMS_OUTPUT.PUT_LINE function.<\/p>\n<p>In addition to storing in a variable, you can also use the SELECT INTO statement to store query results in a table. The syntax is as follows:<\/p>\n<pre class=\"post-pre\"><code>SELECT column_name1, column_name2, ...\r\nINTO table_name\r\nFROM table_name\r\nWHERE condition;\r\n<\/code><\/pre>\n<p>In the above syntax, column_name1, column_name2, &#8230; represent the columns to be queried, table_name is the name of the table where the results will be stored, and condition is the parameter for the query.<\/p>\n<p>For example, the following code will select the names and salaries of employees with the last name &#8220;Smith&#8221; from the employee table and store them in a new table.<\/p>\n<pre class=\"post-pre\"><code>CREATE TABLE new_table AS\r\nSELECT last_name, salary\r\nFROM employees\r\nWHERE last_name = 'Smith';\r\n<\/code><\/pre>\n<p>In the above example, the SELECT INTO statement is used to store the query results in a new table called new_table. The structure of the new table matches the structure of the query results, including the last_name and salary columns.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Oracle, you can use the SELECT INTO statement to store the results of a query into a variable or table. The syntax for storing query results into a variable using the SELECT INTO statement is as follows: SELECT column_name INTO variable_name FROM table_name WHERE condition; In the above syntax, column_name refers to the name [&hellip;]<\/p>\n","protected":false},"author":8,"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":[453,1402,299,1404,1403],"class_list":["post-15820","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-development","tag-guide","tag-programming","tag-technology","tag-tutorial"],"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>What is the method used in Oracle for &quot;select into&quot;? - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn about what is the method used in oracle for &quot;select into&quot;?. Comprehensive guide with examples and best practices.\" \/>\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\/what-is-the-method-used-in-oracle-for-select-into\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the method used in Oracle for &quot;select into&quot;?\" \/>\n<meta property=\"og:description\" content=\"Learn about what is the method used in oracle for &quot;select into&quot;?. Comprehensive guide with examples and best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/\" \/>\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-15T11:47:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T21:49:55+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\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=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"What is the method used in Oracle for &#8220;select into&#8221;?\",\"datePublished\":\"2024-03-15T11:47:47+00:00\",\"dateModified\":\"2025-08-06T21:49:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/\"},\"wordCount\":299,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Development\",\"guide\",\"programming\",\"technology\",\"tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/\",\"name\":\"What is the method used in Oracle for \\\"select into\\\"? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T11:47:47+00:00\",\"dateModified\":\"2025-08-06T21:49:55+00:00\",\"description\":\"Learn about what is the method used in oracle for \\\"select into\\\"?. Comprehensive guide with examples and best practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is the method used in Oracle for &#8220;select into&#8221;?\"}]},{\"@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\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is the method used in Oracle for \"select into\"? - Blog - Silicon Cloud","description":"Learn about what is the method used in oracle for \"select into\"?. Comprehensive guide with examples and best practices.","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\/what-is-the-method-used-in-oracle-for-select-into\/","og_locale":"en_US","og_type":"article","og_title":"What is the method used in Oracle for \"select into\"?","og_description":"Learn about what is the method used in oracle for \"select into\"?. Comprehensive guide with examples and best practices.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T11:47:47+00:00","article_modified_time":"2025-08-06T21:49:55+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"What is the method used in Oracle for &#8220;select into&#8221;?","datePublished":"2024-03-15T11:47:47+00:00","dateModified":"2025-08-06T21:49:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/"},"wordCount":299,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Development","guide","programming","technology","tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/","name":"What is the method used in Oracle for \"select into\"? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T11:47:47+00:00","dateModified":"2025-08-06T21:49:55+00:00","description":"Learn about what is the method used in oracle for \"select into\"?. Comprehensive guide with examples and best practices.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-used-in-oracle-for-select-into\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is the method used in Oracle for &#8220;select into&#8221;?"}]},{"@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\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/15820","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=15820"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/15820\/revisions"}],"predecessor-version":[{"id":49354,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/15820\/revisions\/49354"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=15820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=15820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=15820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}