vezine的博客

centos7 安装oracle11g

=“insert into senderTemp values(’”&A1&"’,’"&C10&"’,to_date(’"&TEXT(I1,“yyyy-mm-dd”)&"’,‘yyyy-MM-dd’));"

创建.bat文件,将以下语句修改成对应数据 sqlplus username/pwd@databasename @"%cd%\test.sql"

conn /as sysdba; shutdown immediate; startup mount; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE character set INTERNAL_USE ZHS16GBK; shutdown immediate; star

DELETE TABLE_NAME WHERE ROWID NOT IN ( SELECT MAX(ROWID) FROM TABLE_NAME T GROUP BY T.COLUMN1,T.COLUMN2 )