I've managed to get it through my programmers heads that they have to ALWAYS
specify column names in any DML statement.
Since they work in the same development database, and often need changes
made to the same parent table, this prevents the "WHO SCREWED UP MY
PROGRAM?" questions
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Insert without telling column names
>Date: Tue, 20 Mar 2001 14:18:13 -0800
>
>
>Well of course it's a bad idea, I thought
>that was obvious. ;)
>
>Jared
>
>On Tue, 20 Mar 2001, Jacques Kilchoer wrote:
>
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > >
> > > How can I create an insert statement without telling all the
> > > names of the columns?
> > > Give an example, please.
> >
> >
> > As Jared mentioned, if you are inserting into all the columns in a
>table,
> > you don't need to specify the column names. But this is a BAD IDEA,
>because
> > if someone adds a column to the table all your insert statements written
> > without column names will fail unless you add values for the new column
>to
> > the insert statement. So while this might be OK when typing in SQL for
> > "one-time" use, don't use this method in any programs/scripts that will
>be
> > used more than once.
> >
> > ------
> > any ignorant comments made are the sole responsibility of J. R. Kilchoer
>and
> > should not reflect adversely upon my employer.
> >
> > Jacques R. Kilchoer
> > (949) 754-8816
> > Quest Software, Inc.
> > 8001 Irvine Center Drive
> > Irvine, California 92618
> > U.S.A.
> > http://www.quest.com
> >
> >
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
