{"id":694,"date":"2011-09-07T03:42:43","date_gmt":"2011-09-07T03:42:43","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=694"},"modified":"2011-09-07T03:42:43","modified_gmt":"2011-09-07T03:42:43","slug":"oracle-export","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/oracmd\/oracle-export.html","title":{"rendered":"Export Oracle data"},"content":{"rendered":"<p>OraCmd is the fast and easy command-line tool to import\/export data, even <strong>without Oracle client<\/strong>.<\/p>\n<p>OraCmd takes the pain out of manual importing\/exporting tasks, and avoids installing the Oracle client.<\/p>\n<p style=\"color: blue; font-weight: bold;\">Convenient, powerful<\/p>\n<ul id=\"features\">\n<li>Export from both table and query.<\/li>\n<li>Export <strong>all<\/strong> tables data in a schema to files in same time.<\/li>\n<li>Export Oracle CLOB data.<\/li>\n<li>Custom unload date format.<\/li>\n<li>Custom unload record delimiter.<\/li>\n<li><a href=\"\/oracmd\/oracmd_unload_to_stdout.html\">Unload data to stdout (not to file)<\/a>.<\/li>\n<li><a href=\"\/oracmd\/oracmd_task.html\">Schedual export task<\/a>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p style=\"color: blue; font-weight: bold;\">Easy to use<\/p>\n<div style=\"margin-left: 15px;\">\n<div><a href=\"\/oracmd\/oracmd_unload_table.html\"><img decoding=\"async\" class=\"image_left\" src=\"\/images\/oracmd\/unload_table.gif\" alt=\"export oracle data from table, click for detail \" width=\"676\" height=\"94\" style=\"max-width:100%;height:auto;display:block;\" \/><\/a><\/p>\n<div>\n<p><a href=\"\/oracmd\/oracmd_unload_table.html\">Export table<\/a> data.<\/p>\n<\/div>\n<\/div>\n<hr style=\"clear: both;\" \/>\n<div><a href=\"\/oracmd\/oracmd_unload_query.html\"><img decoding=\"async\" class=\"image_right\" src=\"\/images\/oracmd\/unload_query.gif\" alt=\"export oracle data from query, click for detail\" width=\"490\" height=\"260\" style=\"max-width:100%;height:auto;display:block;\" \/><\/a><\/p>\n<div>\n<p><a href=\"\/oracmd\/oracmd_unload_query.html\">Export query<\/a> data.<\/p>\n<\/div>\n<\/div>\n<hr style=\"clear: both;\" \/>\n<div><a href=\"\/oracmd\/oracmd_unload_other_schema_tables.html\"><img decoding=\"async\" class=\"image_left\" src=\"\/images\/oracmd\/unload_other_schema_tables.gif\" alt=\"Export Oracle other schema table(s), click for detail \" width=\"556\" height=\"202\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/a><\/p>\n<div>\n<p><a href=\"\/oracmd\/oracmd_unload_other_schema_tables.html\">Export Oracle other schema table(s)<\/a> .<\/p>\n<\/div>\n<\/div>\n<hr style=\"clear: both;\" \/>\n<div><a href=\"\/oracmd\/oracmd_unload_clob.html\"><img decoding=\"async\" class=\"image_right\" src=\"\/images\/oracmd\/unload_clob.gif\" alt=\"Export oracle CLOB data, click for detail\" width=\"576\" height=\"81\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/a><\/p>\n<div>\n<p><a href=\"\/oracmd\/oracmd_unload_clob.html\">Export CLOB<\/a> data.<\/p>\n<\/div>\n<\/div>\n<hr style=\"clear: both;\" \/>\n<div><a href=\"\/oracmd\/oracmd_unload_custom_date_format.html\"><img decoding=\"async\" class=\"image_left\" src=\"\/images\/oracmd\/unload_custom_date_format.gif\" alt=\"custom oracle unload date format, click for detail\" width=\"700\" height=\"49\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/a><\/p>\n<div>\n<p><a href=\"\/oracmd\/oracmd_unload_custom_date_format.html\">Custom unload date format<\/a>.<\/p>\n<\/div>\n<\/div>\n<hr style=\"clear: both;\" \/>\n<div><a href=\"\/oracmd\/oracmd_unload_custom_record_delimiter.html\"><img decoding=\"async\" class=\"image_right\" src=\"\/images\/oracmd\/unload_custom_record_delimiter.gif\" alt=\"custom oracle unload record delimiter, click for detail\" width=\"462\" height=\"101\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/a><\/p>\n<div>\n<p><a href=\"\/oracmd\/oracmd_unload_custom_record_delimiter.html\">Custom unload record delimiter<\/a>.<\/p>\n<\/div>\n<\/div>\n<hr style=\"clear: both;\" \/>\n<\/div>\n<div style=\"clear: both;\">\n<p><a href=\"\/oracmd.html\">OraCmd<\/a> is a command-line tools that can run sql command, import\/export data, even without Oracle client.<\/p>\n<p><span style=\"padding-right: 20px;\">30-day free trial <a onclick=\"logClick('oracmd_ad_download_bottom');\" href=\"http:\/\/www.withdata.com\/down\/OraCmd.exe\"><img decoding=\"async\" src=\"\/images\/btn_download_green.gif\" alt=\"Download OraCmd\" border=\"0\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a><\/span><span>US$49.95 <a onclick=\"logClick('oracmd_ad_purchase_bottom');\" href=\"\/purchase_oracmd.html\"><img decoding=\"async\" src=\"\/images\/btn_buynow_green.gif\" alt=\"Buy OraCmd\" border=\"0\" width=\"136\" height=\"41\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span>\u00a0<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>OraCmd is the fast and easy command-line tool to import\/export data, even without Oracle client. OraCmd takes the pain out of manual importing\/exporting tasks, and avoids installing the Oracle client. Convenient, powerful Export from both table and query. Export all tables data in a schema to files in same time. Export Oracle CLOB data. Custom [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[73,16,38,1325],"class_list":["post-694","post","type-post","status-publish","format-standard","hentry","category-oracmd","tag-command-line","tag-export","tag-flat-file","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=694"}],"version-history":[{"count":2,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/694\/revisions"}],"predecessor-version":[{"id":697,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/694\/revisions\/697"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}