iteye_13327的博客

  declare begin for t in 1..10 loop begin insert into t_bns_share_log (ID) values(nulll);/* 如果ID不能为空的情况下 */ exception when others then insert into t_bns_share_log (ID) values(hibernate_sequen...

select count(*) from v$process --当前的连接数select value from v$parameter where name = 'processes' --数据库允许的最大连接数修改最大连接数:alter system set processes = 300 scope = spfile;重启数据库:shutdown immediate;startup;--查看...

表空间下所有的表里CHAR类型的字段改成VARCHAR2,由于数据表字段太多，一个一个改太麻烦，所以我就想到了如下方式：   DECLARE CURSOR TEMP IS SELECT TABLE_NAME,COLUMN_NAME,DATA_LENGTH FROM USER_TAB_COLUMNS WHERE DATA_TYPE = 'CHAR'; STR VARCHA...