Happy new year, guten Rutsch (german) and bonne et joyeuse année 2010 (french) to all my readers.
Next year I will continue with more stuff about Oracle Fusion Middleware 11g and Enterprise Content Management. So stay tune ... :-)
This Blog is discontinued, its only read-only
select * from dual; D - X select count(*) from dual; COUNT(*) -------- 1 insert into dual values ('Y'); commit;
conn scott/tiger drop table t1; ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows select * from dual; D - X
select * from dual; D - X
create table copy_dual as select * from dual; select * from copy_dual; D -- X YAnd here we can see the two rows :-)
delete from dual where dummy = 'Y'; commit;Addendum: Under Oracle 11.2.0.1.0 the error with the drop table command doesn't come up again