t22011787

介绍orcale定时器的简单用法，希望大家一看就能明白 [b]1.创建一个表，为了能清楚看到定时器的运行情况我们创建一个带有日期字段的表[/b] [code="sql"]create table job_table(run_time date);[/code] [b]2.创建存储过程[/b] [code="sql"]create or replace procedure job_p...

[code="sql"]select status,program,username,sid,serial# from v$session where username='username' AND STATUS='INACTIVE'[/code] [code="sql"]alter system kill session 'sid,serial# '[/code] ...

[code="sql"]select rtrim(Kmdm) as Kmdm, rtrim(Fzhs) as Fzhs, rtrim(Yefx) as Yefx, rtrim(Kmlb) as Kmlb, '${annual}' as annual, '${ACCOUNT_CODE}' as ACCOUNT_CODE, kmxz,rtrim(kmmc) as k...

[table] |code| | 10002| |10012.0| | 112.0| |158| [/table] 去除左右空格 [code="sql"] update TB_PRICED_MATERIALS set code=trim(code) [/code] 去除.0 [code="sql"] update TB_PRICED_MATERIALS set cod...

http://www.cnblogs.com/malaikuangren/archive/2012/04/06/2434760.html