方法1:Select translate('254名字性别介绍','1234567890名字性别介绍’','1234567890') From dual方法2:看俺的java实现首先:create or replace and compile java source named stringutil asimport Java.io.*;import Java.sql.*;public class StringUtil{public static String filterStr2Num(Stri...【阅读全文】
--方法1declarecursor tmp_cur(tmp_num NUMBER) IS select * from tables where part_num=tmpnum;beginfor emp_record in tmp_cur(123) loop..............end loop;end;--方法2declarebeginfor emp_record in (select * from tables where part_num=123) loop..............end loop;end;...【阅读全文】
In 10g, parallel execution in RAC instances is controlled with two initialization parameters: INSTANCE_GROUPS and PARALLEL_INSTANCE_GROUP. Both must be used together in 10g.INSTANCE_GROUPS can have multiple values but it is static; PARALLEL_INSTANCE_GROUP can be modified dynamically at the s...【阅读全文】
问题:使用select 查询时,提示“ORA-01795:列表中的最大表达式数为1000”原因:IN中引用的数据超过了1000条解决方法:如果IN引用数据大于1000的话可以用OR语句它拆分成两个或多个in就OK了举例:Select * from tablename where col in (‘col1’,’col2’ ……..)如果in 后面的Item过多的话,超过1000就会出现这种...【阅读全文】