oracle数据库查询表数据的sql插入语句

你可以使用以下 SQL 语句来查询表数据并生成插入语句：

-- 生成插入语句
SELECT 'INSERT INTO ' || table_name || ' (' || column_name_list || ') VALUES (' || value_list || ');'
FROM (
    -- 查询表名、列名和值
    SELECT table_name, 
           listagg(column_name, ', ') WITHIN GROUP (ORDER BY column_id) AS column_name_list, 
           listagg(DECODE(data_type, 'DATE', 'TO_DATE(''%'', ''YYYY-MM-DD HH24:MI:SS'')', 'VARCHAR2', '''%'', data_type) || 
                   DECODE(data_type, 'DATE', column_value, 'VARCHAR2', REPLACE(column_value, '''', ''''''')) || 
                   DECODE(data_type, 'NUMBER', column_value) || 
                   DECODE(data_type, 'CHAR', '''' || REPLACE(column_value, '''', ''''''') || '''') 
                   , ', ') WITHIN GROUP (ORDER BY column_id) AS value_list
    FROM (
        -- 查询数据
        SELECT table_name, column_name, column_id, data_type, 
               CASE 
                   WHEN data_type = 'DATE' THEN to_char(column_value, 'YYYY-MM-DD HH24:MI:SS') 
                   ELSE column_value 
               END AS column_value
        FROM (
            -- 查询所有表和列名
            SELECT table_name, column_name, column_id, data_type
            FROM user_tab_columns
            WHERE table_name = 'YOUR_TABLE_NAME'
            ORDER BY column_id
        ) t1
        JOIN (
            -- 查询表数据
            SELECT *
            FROM YOUR_TABLE_NAME
        ) t2
        ON t1.column_name = t2.column_name
    )
    GROUP BY table_name
);

将 `YOUR_TABLE_NAME` 替换为你要查询的表名即可。以上 SQL 语句会生成插入表中所有数据的 SQL 语句，你可以将其复制到 SQL 开发工具中执行。