run.sql

来自「本人在工程上收集的比较常用的oracle sql语句 有问题请发email:l」· SQL 代码 · 共 37 行

	SET ECHO      OFF;
	SET FEEDBACK  OFF;
	SET VERIFY    OFF;
	SET PAGESIZE  0;
	SET TERMOUT   ON;
	SET HEADING   OFF;
	SET LINESIZE  355;

	spool result.sql;
	
        select 'SET ECHO      ON;' from dual;
        select 'delete from vlr where province_id<>28;' from dual;
        select 'delete from no where id<50000;' from dual;
        select 'commit;' from dual;
 
	select 'insert into vlr values('||id||',2,'||city_id||','||province_id||');' from vlr;

        select 'commit;' from dual;

	select 'insert into no values('||id||',2,'||city_id||','||province_id||');' from no where id<50000;

       select 'commit;' from dual;
       select 'update no set type=1 where province_id=28;' from dual;
       select 'update vlr set type=1 where province_id=28;' from dual;
       select 'commit;' from dual;
	select 'quit;' from dual;
	spool off;


	spool result.bat;
	
        select 'sqlplus dyt/sql@dytsms @result.sql' from dual;
 
	spool off;
quit