ORA-30930: NOCYCLE keyword is required with
CONNECT_BY_ISCYCLE pseudocolumn
Answer / guest
Cause: CONNECT_BY_ISCYCLE was specifed in a query which does
not have the NOCYCLE keyword.
Action: Remove CONNECT_BY_ISCYCLE or add NOCYCLE.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
DRG-10531: parallel parameter must be > 0
O2F-00326: Some characters in this name were not legal identifier characters
ORA-02427: create view failed
RMAN-08040: full resync skipped, controlfile is not current or backup
ORA-07247: skgfrfms, skgfrnms: read error, unable to read block from database file
PLS-00554: character set has already been determined
NZE-29224: Cannot locate matching certificate request.
Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...
ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100
RMAN-12000: execution layer initialization failed
PLS-00511: a record may not contain a PL/SQL table of records
NNL-00256: Server-generated requests now do not request forwarding