{"id":8179,"date":"2024-03-14T07:40:20","date_gmt":"2024-03-14T07:40:20","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/"},"modified":"2025-08-03T01:33:37","modified_gmt":"2025-08-03T01:33:37","slug":"how-can-you-duplicate-a-table-and-its-data-in-pl-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/","title":{"rendered":"Duplicate Table in PL\/SQL"},"content":{"rendered":"<p>In PL\/SQL, you can use the following statement to duplicate a table and its data:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> new_table <span class=\"hljs-keyword\">AS<\/span>\r\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span> old_table;\r\n<\/code><\/pre>\n<p>In this statement, new_table is the name of the new table to be created, and old_table is the name of the original table to be copied. This statement will copy the structure and data of the original table to the new table.<\/p>\n<p>Additionally, you can also use the INSERT INTO statement to duplicate table data.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">INTO<\/span> new_table\r\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span>\r\n<span class=\"hljs-keyword\">FROM<\/span> old_table;\r\n<\/code><\/pre>\n<p>This statement only copies the table data, not the table structure. It is important to note that the structure of the new table must exactly match the structure of the original table, otherwise an error will be thrown.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In PL\/SQL, you can use the following statement to duplicate a table and its data: CREATE TABLE new_table AS SELECT * FROM old_table; In this statement, new_table is the name of the new table to be created, and old_table is the name of the original table to be copied. This statement will copy the structure [&hellip;]<\/p>\n","protected":false},"author":5,"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":[10845,10844,3302,321,10846],"class_list":["post-8179","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-copy-table","tag-duplicate-table","tag-oracle-pl-sql","tag-pl-sql","tag-sql-table-copy"],"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>Duplicate Table in PL\/SQL - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to duplicate tables and data in PL\/SQL with CREATE TABLE AS and INSERT INTO methods. Quick guide!\" \/>\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-can-you-duplicate-a-table-and-its-data-in-pl-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Duplicate Table in PL\/SQL\" \/>\n<meta property=\"og:description\" content=\"Learn how to duplicate tables and data in PL\/SQL with CREATE TABLE AS and INSERT INTO methods. Quick guide!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/\" \/>\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-14T07:40:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-03T01:33:37+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\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=\"Emily Johnson\" \/>\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-can-you-duplicate-a-table-and-its-data-in-pl-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"Duplicate Table in PL\/SQL\",\"datePublished\":\"2024-03-14T07:40:20+00:00\",\"dateModified\":\"2025-08-03T01:33:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/\"},\"wordCount\":116,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"copy table\",\"duplicate table\",\"Oracle PL\/SQL\",\"PL\/SQL\",\"SQL table copy\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/\",\"name\":\"Duplicate Table in PL\/SQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T07:40:20+00:00\",\"dateModified\":\"2025-08-03T01:33:37+00:00\",\"description\":\"Learn how to duplicate tables and data in PL\/SQL with CREATE TABLE AS and INSERT INTO methods. Quick guide!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Duplicate Table in PL\/SQL\"}]},{\"@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\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Duplicate Table in PL\/SQL - Blog - Silicon Cloud","description":"Learn how to duplicate tables and data in PL\/SQL with CREATE TABLE AS and INSERT INTO methods. Quick guide!","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-can-you-duplicate-a-table-and-its-data-in-pl-sql\/","og_locale":"en_US","og_type":"article","og_title":"Duplicate Table in PL\/SQL","og_description":"Learn how to duplicate tables and data in PL\/SQL with CREATE TABLE AS and INSERT INTO methods. Quick guide!","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T07:40:20+00:00","article_modified_time":"2025-08-03T01:33:37+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"Duplicate Table in PL\/SQL","datePublished":"2024-03-14T07:40:20+00:00","dateModified":"2025-08-03T01:33:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/"},"wordCount":116,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["copy table","duplicate table","Oracle PL\/SQL","PL\/SQL","SQL table copy"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/","name":"Duplicate Table in PL\/SQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T07:40:20+00:00","dateModified":"2025-08-03T01:33:37+00:00","description":"Learn how to duplicate tables and data in PL\/SQL with CREATE TABLE AS and INSERT INTO methods. Quick guide!","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-duplicate-a-table-and-its-data-in-pl-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Duplicate Table in PL\/SQL"}]},{"@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\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8179","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=8179"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8179\/revisions"}],"predecessor-version":[{"id":152978,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/8179\/revisions\/152978"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=8179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=8179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=8179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}