- 博客(2)
- 收藏
- 关注
RSS订阅原创 orcale 以逗号切割某个字符串 放入in中
SELECT * FROM TAB_A T1 WHERE T1.CODE IN ( SELECT REGEXP_SUBSTR (‘1,2,3,4,5,6,7,8,9,0’,’[^,]+’,1,LEVEL) FROM DUAL CONNECT BY REGEXP_SUBSTR (‘1,2,3,4,5,6,7,8,9,0’,’[^,]+’,1,LEVEL) IS NOT NULL )
2021-06-03 18:27:53
192
原创 orcale查询表字段
Select max(SYS_CONNECT_BY_PATH(COLUMN_NAME, ', ')) From (select A.COLUMN_NAME,A.TABLE_NAME, ROWNUM AS ROWNO from USER_TAB_COLUMNS A where TABLE_NAME = ‘必须大写表名’ ORDER BY A.COLUMN_ID) start with ROWNO = 1 connect by ROWNO = rownum;
2020-08-14 16:55:40
104
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人