wjm901215的专栏

create or replace procedure p_sendsms(l_type         in varchar2,                                      l_phoneNo      in varchar2,                                      l_content      in varchar2,     ...

1、查看锁定对像   SELECT A.OWNER 方案名,         A.OBJECT_NAME 表名,         B.XIDUSN 回滚段号,         B.XIDSLOT 槽号,         B.XIDSQN 序列号,         B.SESSION_ID 锁表SESSION_ID,         B.ORACLE_USERNAME 锁表用户名,       ...

package com.innotek;import java.beans.PropertyVetoException;import java.sql.Connection;import java.sql.SQLException;import java.text.SimpleDateFormat;import com.mchange.v2.c3p0.ComboPool...

有时候连得上数据库,有时候又连不上.可能是数据库上当前的连接数目已经超过了它能够处理的最大值select count(*) from v$process --当前的连接数select value from v$parameter where name = 'processes' --数据库允许的最大连接数修改最大连接数:alter system set processes ...

//oracle中extract()函数从oracle 9i中引入,用于从一个date或者interval类型中截取到特定的部分//语法如下：EXTRACT ( { YEAR | MONTH | DAY | HOUR | MINUTE | SECOND } | { TIMEZONE_HOUR | TIMEZONE_MINUTE } |...

select pk_table 主键表,pk_col 主键表ID,fk_table 外键表,fk_col 外键表ID,pk_con constraint_name,del_rule dellete_rulefrom (select a.constraint_name pk_con,a.table_name pk_table,b.column_name pk_col,a.owner pk_owne...

create or replace function soap_call ( p_req_body in varchar2 , p_target_url in varchar2 , p_soap_action in varchar2 default 'none' ) return xmltype is l_soap_request varch...