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