select T1.MATERIALNAME as rownum,T1.CASENO,T1.MATERIALNAME,T1.MATERIALID,T2.FILENAME,T2.FILENO,T2.FILECONTENT FROM CASEMATERIALLIST T1 LEFT JOIN UPFILESLIST T2 ON T1.CASENO=T2.CASENO AND T1.MATERIALID=T2.MATERIALID WHERE T1.CASENO='GWFW-2010-0000003' ORDER BY T1.MATERIALID,T2.FILENO 查出上面的数据 插入到Oracle表中对应的字段中
查出上面的数据 插入到Oracle表中对应的字段中
通过 OracleCommandBuilder更新数据
或sql server的导入导出
sqldeveloper