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.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"