java /oracle字符串操作

1.        String parentLimt="578,579,580,581,";
           System.out.println(parentLimt.contains("578"));

           结果为true

2.   去掉一个某个字符
       StringBuffer parentLimtbuff = new StringBuffer(parentLimt);
       parentLimtbuff.deleteCharAt(parentLimt.length()-1);
       System.out.println(parentLimtbuff.toString());

3.字符串转成数组

  String[] limitarr = parentLimt.split(",");

 

oracle

1.

  select replace('a,b,c,d,','a,') from dual a ;

结果为:b,c,d,

 

2.

select instr('a,b,c,d,','a,') from dual a ;

结果为:1