java中substring(int beginIndex,int endIndex)表示从截取beginIndex到endIndex个字符
String str="safsdgas";
System.out.println("str05 "+str.substring(0, 5));
System.out.println("str15 "+str.substring(1, 5));
System.out.println("str35 "+str.substring(3, 5));
打印出来的结果是:
str05 safsd
str15 afsd
str35 sd
而oracle数据库中的substr截取函数举例
select substr('asfsff',0,3) from dual ;
select substr('asfsff',1,3) from dual ;
输出结果是:
asf
asf