Re: Duplicate inserts but only through sqlplus

On 11 Apr 2007 14:06:42 -0700, "Anoop" <anoopkumarv_at_gmail.com> wrote:

>never mind all - I figured out the solution. It was the comments that
>I had included in the file. Once I removed the comments (/* XXX */),
>it works perfectly, no duplicates at all.
>
>But still - beats me: Why would sqlplus insert duplicates if there are
>comments like /* XXX */.

The answer to this is very simple: you don't have primary or unique keys on the affected table and the / means 'run the current buffer'

This has nothing to do with Oracle, but everything with bad design and bad programming.

-- 
Sybrand Bakker
Senior Oracle DBA