<i id='twhcE'><tr id='twhcE'><dt id='twhcE'><q id='twhcE'><span id='twhcE'><b id='twhcE'><form id='twhcE'><ins id='twhcE'></ins><ul id='twhcE'></ul><sub id='twhcE'></sub></form><legend id='twhcE'></legend><bdo id='twhcE'><pre id='twhcE'><center id='twhcE'></center></pre></bdo></b><th id='twhcE'></th></span></q></dt></tr></i><div id='twhcE'><tfoot id='twhcE'></tfoot><dl id='twhcE'><fieldset id='twhcE'></fieldset></dl></div>
    <legend id='twhcE'><style id='twhcE'><dir id='twhcE'><q id='twhcE'></q></dir></style></legend>

    <tfoot id='twhcE'></tfoot>

        • <bdo id='twhcE'></bdo><ul id='twhcE'></ul>
      1. <small id='twhcE'></small><noframes id='twhcE'>

        Oracle:将选择语句结果集导出为类似于 SQL 开发人员导出的 INSERT SQL 语句

        Oracle : Export select statement result set as INSERT SQL Statements similar to SQL developer export(Oracle:将选择语句结果集导出为类似于 SQL 开发人员导出的 INSERT SQL 语句)

        <small id='KDrby'></small><noframes id='KDrby'>

            <tbody id='KDrby'></tbody>

          <i id='KDrby'><tr id='KDrby'><dt id='KDrby'><q id='KDrby'><span id='KDrby'><b id='KDrby'><form id='KDrby'><ins id='KDrby'></ins><ul id='KDrby'></ul><sub id='KDrby'></sub></form><legend id='KDrby'></legend><bdo id='KDrby'><pre id='KDrby'><center id='KDrby'></center></pre></bdo></b><th id='KDrby'></th></span></q></dt></tr></i><div id='KDrby'><tfoot id='KDrby'></tfoot><dl id='KDrby'><fieldset id='KDrby'></fieldset></dl></div>
        • <legend id='KDrby'><style id='KDrby'><dir id='KDrby'><q id='KDrby'></q></dir></style></legend>

              <tfoot id='KDrby'></tfoot>

                • <bdo id='KDrby'></bdo><ul id='KDrby'></ul>
                • 本文介绍了Oracle:将选择语句结果集导出为类似于 SQL 开发人员导出的 INSERT SQL 语句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我正在寻找一种解决方案来为 select 语句结果集创建 SQL INSERT 语句使用 PL/SQL 脚本.寻找 SQL Developer 工具中可用的类似功能(导出 --> 格式插入),但我希望将解决方案作为脚本而不是使用任何工具.

                  I am looking for a solution to create the SQL INSERT statements using PL/SQL script for the select statement result set. Looking for similar feature available in the SQL Developer tool (export --> format insert) but I want the solution as script rather than using any tool(s).

                  我参考了以下解决方案.但是,我想知道是否有更好的方法来做到这一点,因为该解决方案很旧而且不是很简单.

                  I have referred the below solution. However, I would like to know whether any better way to do it as the solution is old and not very simple.

                  导出为插入声明:但在 SQL Plus 中,该行覆盖了 2500 个字符!

                  推荐答案

                  我刚刚为我的问题找到了一个简单的解决方案使用 oracle 提示(插入").这会自动处理数据类型为好.我的表只有字符串和数字数据类型,所以它对我来说很好用.我还没有测试其他数据类型的解决方案.但是,我希望它也适用于其他数据类型.

                  I just found a simple solution for my problem using oracle hint ("insert"). This automatically take care the data type as well. My table has only string and numeric data types, so it works fine for me. I have not tested the solution for other data types. However, I hope it would work for other data types as well.

                  set linesize 2000
                  set pagesize 10
                  spool "c:myoutput.txt";
                  select /*insert*/ * from SAMPLE_TABLE;
                  spool off;
                  

                  这篇关于Oracle:将选择语句结果集导出为类似于 SQL 开发人员导出的 INSERT SQL 语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  How to call Oracle function or stored procedure using spring persistence framework?(如何使用 Spring 持久化框架调用 Oracle 函数或存储过程?)
                  What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors(什么会导致间歇性 ORA-12519(TNS:找不到合适的处理程序)错误)
                  SQL to return the number of working days between 2 passed in dates(SQL 返回两个传入日期之间的工作日数)
                  Oracle Date Subtraction(Oracle 日期减法)
                  Is using quot;select *quot; for a cursor in PL/SQL considered bad programming?(正在使用“选择 *PL/SQL 中的游标被认为是糟糕的编程?)
                  Using sql/plsql, how do you find out which character set a text uses?(使用 sql/plsql,你如何找出文本使用的字符集?)
                      <bdo id='djIzc'></bdo><ul id='djIzc'></ul>

                          <tbody id='djIzc'></tbody>
                      1. <tfoot id='djIzc'></tfoot>

                        <small id='djIzc'></small><noframes id='djIzc'>

                          <legend id='djIzc'><style id='djIzc'><dir id='djIzc'><q id='djIzc'></q></dir></style></legend>
                          <i id='djIzc'><tr id='djIzc'><dt id='djIzc'><q id='djIzc'><span id='djIzc'><b id='djIzc'><form id='djIzc'><ins id='djIzc'></ins><ul id='djIzc'></ul><sub id='djIzc'></sub></form><legend id='djIzc'></legend><bdo id='djIzc'><pre id='djIzc'><center id='djIzc'></center></pre></bdo></b><th id='djIzc'></th></span></q></dt></tr></i><div id='djIzc'><tfoot id='djIzc'></tfoot><dl id='djIzc'><fieldset id='djIzc'></fieldset></dl></div>