ORA ORA-02014 ORA-02014 cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.Cause: An attempt was made to SELECT... FOR UPDATE from a view whose defining SELECT
statement uses at least one of the following constructs in its outer block: outer join,
GROUP BY clause, aggregate functions, SELECT DISTINCT, CONNECT BY clause, or set
operation, UNION, INTERSECT, or MINUS. Action: Do not use SELECT... FOR UPDATE on this view.
statement uses at least one of the following constructs in its outer block: outer join,
GROUP BY clause, aggregate functions, SELECT DISTINCT, CONNECT BY clause, or set
operation, UNION, INTERSECT, or MINUS. Action: Do not use SELECT... FOR UPDATE on this view.
解决方案 »
- 问下,,ORACLE里面什么时候用COMMIT啊?
- 关于ORACLE11G模糊查询的疑问
- 如何获取以函数表示的列名?急急急,求大神赐教。
- 虚拟机配置oralcle RAC,安装集群件,在 执行root.sh时的错误
- 如何确定某一天所在的周是一年的第几周?
- 求一sql
- 在windows2003server上安装oracle9i时为何出现死机现象?
- 关于触发器更改标志位问题,急,万分感谢
- 一个ORACLE开发初学者的问题??????(讲得多给的多)
- 各位大神,谁能帮我将下面mssql语句转换成oracle的?
- 请问如何打开位图索引选项?
- "ORA-03127: 在活动操作结束之前不允许进行新的操作"是什么意思?
select x.* from (select rownum t,hinmoku_mst.* from hinmoku_mst)x where x.t>20 and x.t<40
最后加上 for update 后仍然出和上面一样的错误,我估计是因为rownum这个伪列和表中的列组成的视图x oracle无法进行锁操作,感觉oracle只能对固定的表的行数据才能进行加锁,所以请各位指教
表结构如下:
CREATE TABLE HINMOKU_MST
(
ZHIBAN CHAR(50) NOT NULL,
HINBAN CHAR(50) NOT NULL,
START_DATE CHAR(16),
END_DATE CHAR(16),
LONG_NM VARCHAR2(60),
LONG_NM_E VARCHAR2(60),
LONG_NM_J VARCHAR2(60),
SHORT_NM VARCHAR2(30),
SHORT_NM_E VARCHAR2(30),
SHORT_NM_J VARCHAR2(30),
BUNRUI_CD CHAR(10),
JAN_CD CHAR(14),
ZAIKU_KBN CHAR(5),
APS_SALES_KBN CHAR(5),
PLAN_HOUSIKI CHAR(5),
ORG_CD CHAR(10),
LLC NUMBER(5,0),
ADD_TAN_CD CHAR(10),
ADD_DATE DATE,
UPD_TAN_CD CHAR(10),
UPD_DATE DATE,
DEL_FLG CHAR(1),
CONSTRAINT PK_HINMOKU PRIMARY KEY (ZHIBAN, HINBAN)
)
You cannot specify this clause with the following other constructs: the DISTINCT operator, CURSOR expression, set operators, group_by_clause, or aggregate functions.
The tables locked by this clause must all be located on the same database, and on the same database as any LONG columns and sequences referenced in the same statement.