□黑无常□

-- INSTR(源字符串, 要查找的字符串, 从第几个字符开始, 要找到第几个匹配的序号) select INSTR('ni..ha,.owcao,nia,.m,.. ,bi',',', 3, 2) from dual---------------------------------------  1

SELECT LEVEL LV FROM DUAL CONNECT BY LEVEL <= 100 select rownum no from dual connect by rownum < =100

1.死的 SELECT trim(REGEXP_SUBSTR (replace('aa,bb,cc',''), '[^,]+', 1,ROWNUM)) as keywords from dual t CONNECT BY ROWNUM <=length(regexp_replace('aa,bb,cc','[^,]',''))+1

MERGE INTO EMP1 TUSING (SELECT A.ID,A.NAME,A.PASSWORD FROM EMP A )S ON (T.ID=S.ID)WHEN MATCHED THEN UPDATE SET T.NAME=S.NAME, T.PASSWORD=S.PASSWORDWHE

替代函数 和java'中的replace差不多 select REPLACE('aaa,aaa', ',' ,'..') from dual-----------------------------------------------------1 aaa..aaa select REPLACE('aaa,aaa', ',','') from dual

SELECT * FROM ALL_TABLES;系统里有权限的表SELECT * FROM DBA_TABLES; 系统表查询数据库中所有表中的所有条数 SELECT Table_Name,NUM_ROWS FROM USER_TABLES;