RE: Insert without telling column names

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: Roland.Skoldblom_at_ica.se [mailto:Roland.Skoldblom_at_ica.se]
> >
> > 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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).