Re: Order of columns in a table

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SuzyV
  INET: lvordos_at_datsit.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).