首先确定表数据
然后执行导出命令
SET FEEDBACK OFF
SET HEADING OFF
SET TRIMSPOOL ON
SET PAGESIZE 0
SET LINESIZE 32767
SET FEEDBACK 6
SPOOL BPM_EXT_PROCINST.sql
SELECT 'INSERT INTO BPM_EXT_PROCINST (ID, BUSI_ID, BUSI_NAME, BUSI_TYPE_ID, BUSI_TYPE_NAME, START_TIME, END_TIME, PROCDEP_ID, J4_PI_ID, J4_PI_DBID, J4_PI_STATE) VALUES (' ||
TO_CHAR(ID) || ', ''' ||
REPLACE(BUSI_ID, '''', '''''') || ''', ''' ||
REPLACE(BUSI_NAME, '''', '''''') || ''', ''' ||
REPLACE(BUSI_TYPE_ID, '''', '''''') || ''', ''' ||
REPLACE(BUSI_TYPE_NAME, '''', '''''') || ''', ''' ||
TO_CHAR(START_TIME, 'YYYY-MM-DD HH24:MI:SS') || ', ' ||
TO_CHAR(END_TIME, 'YYYY-MM-DD HH24:MI:SS') || ', ''' ||
REPLACE(PROCDEP_ID, '''', '''''') || ''', ''' ||
REPLACE(J4_PI_ID, '''', '''''') || ''', ''' ||
REPLACE(J4_PI_DBID, '''', '''''') || ''', ''' ||
REPLACE(J4_PI_STATE, '''', '''''') || ''');' AS insert_statement
FROM BPM_EXT_PROCINST;
SPOOL OFF
涉及中文，添加中文环境变量
export NLS_LANG=.AL32UTF8 sqlplus username/password@database
标签：BUSI,SET,J4,oracl,REPLACE,sqlplus,sql,PI,ID From： https://www.cnblogs.com/libruce/p/18500027