Am I an idiot?? Meant to say, you can eliminate the COLUMN list not VALUES,
doh!
SuzyV wrote:
>
> select table_name, column_name from dba_tab_columns
> where table_name = 'SOMETABLE' order by column_id ;
>
> The column order is the same as you'd see with describe or select *
>
> You can eliminate VALUES from insert when inserting a value (or null) for each
> column and in the proper order.
>
> Helmut Daiminger wrote:
> >
> > Hi!
> >
> > How can I find out what the order of columns in a table is?
> >
> > If I do a select * from tablename, the columns appear in a specific order.
> > The same order than they appear when I do a describe tablename.
> >
> > I can even do an insert without specifying the columns in my VALUES
> > (.....,....) when they are in that specific order.
> >
> > How and where can I find the order of the columns within a table?
> >
> > Any ideas?
> >
> > Yhis is 8.1.6 on Win2k.
> >
> > Thanks,
> > Helmut
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Helmut Daiminger
> > 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SuzyV
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).
