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).
