ORA-01795: 列表中的最大表达式数为 1000-白红宇的个人博客

ORA-01795: 列表中的最大表达式数为 1000

发布日期：2025-04-29 08:40:17 浏览次数：14 分类：精选文章

本文共 952 字，大约阅读时间需要 3 分钟。

???Oracle?MySQL?MSSQL????create_by????????

???

???????????????????create_by????????????????????????????????????????????????create_by????????

?????

??????????create_by??????????????????????????????????????create_by?????????????????????????????

??????????create_by??????????????????????????????????????????????

????????????????????????????????

WHERE create_by IN (    SELECT u.id as "CREATE_BY_ID"    FROM sys_user u    WHERE u.name LIKE '%'||#{createBy.name}|| '%')

WHERE create_by IN (    SELECT u.id as "CREATE_BY_ID"    FROM sys_user u    WHERE u.name LIKE '%'+#{createBy.name}+'%')

WHERE create_by IN (    SELECT u.id as "CREATE_BY_ID"    FROM sys_user u    WHERE concat(u.name, '%') LIKE '%#{createBy.name}%')

?????????????????????????????????????????????????????????

??????????????????????????????????????????????????????????

???????Oracle?MSSQL?MySQL???????????????create_by????????

下一篇：ORA-01207:文件比控制文件更新 - 旧的控制文件

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！