I got this error: ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here Everywhere I'm searching says remove level, but I can't remove level. Where is level allowed? SELECT t1.report_id, coalesce(t1.field_desc, t2.field_desc, 'None') field_desc FROM dual LEFT JOIN v_my_view t1 O...
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]: ORA-00976 When Using ROWNUM as Values For Insert
I've written a query to attempt to do this using 'levels' -- but oracle is giving me the error message: ORA-00976: Specified pseudocolumn or operator not allowed here. Whenever I include 'level' in the 'ON'. and I am very unsure how I can tweak this query to wo...
然后,您可以在单个语句中执行插入(无需PL/SQL或循环):
然后,您可以在单个语句中执行插入(无需PL/SQL或循环):