Originally posted by DaPi
I remember a post where someone had managed to get TWO rows in dual
Even after inserting new value into dual, oracle managed to retrive just one row, being smart by putting rownum=1 internally.
However in PL/SQL block it would fail with exact fetch returns more than one row

But if we create DUAL tab like this, we will get number of rows inserted, since oracle now thinks it as an user object.