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