ORCACLE数据窗口的两个问题
1、SELECT :as_user as LOGONNAME,
A.ID as ID,
1 As FLAG,
1 As OWNED,
(select B.RIGHTNAME
from RIGHTS B
where B.flag = 1 and
A.ID = B.ID) As RIGHTNAME
FROM USERRIGHTS A
WHERE A.LOGONNAME = :as_user AND
A.FLAG = 1
union
select :as_user as LOGONNAME,
C.ID as id,
1 as FLAG,
0 as OWNED,
C.RIGHTNAME as RIGHTNAME
from RIGHTS C
where C.flag = 1 and
C.ID not in
(select D.Id from USERRIGHTS D where D.Flag = 1 and D.LOGONNAME = :as_user)
ORDER BY RIGHTNAME ASC
超级奇怪的是:
当我输入一个检索条件,如:xzeng的时候,结果LOGONNAME只能显示成xz,也就是只能显示两位
很不明白是什么原因,请各位帮忙解释一下。