Re: question about sequences.

On 4 Mar 2003, peter.sharman_at_oracle.com wrote:

> It's something that you used to be able to do in earlier
> releases (before 8.1.something IIRC). I know, I had this exact
> problem when we let a manager (yes, I know, I know) do
> maintenance one night - ended up with 2 rows in DUAL and every
> form for every application errored out the next morning because
> they all included a date-time field on them (single row query
> returns more than one row type error).

I would have failed that interview. I've never thought about doing that and I've never had to deal with an issue caused by it.

> In later editions, we put the smarts into the kernel to ensure
> you CAN'T screw up like this, so it must have happened fairly
> frequently. :) Now I think you can do inserts, deletes and all
> sorts of things, get no errors, but still only end up with one
> row in DUAL, becaue it's no longer really a table (IMSMC it's a
> synonym on X$DUAL?)

Sounds like the correct fix.

-- 
Galen Boyer