Re: Select * and column names

From: Zbigniew Sliwa <zibi_at_at_hotmail.com>
Date: 2000/08/04
Message-ID: <5Ssi5.13649$ct3.320504@news.tpnet.pl>#1/1

Hi,

What about column_id?
I think that this column refer to the order of table columns.

So, try this:

SELECT *

FROM      dba_tab_columns
WHERE     table_name = 'table_name_in_upper_case'

ORDER BY column_id

---

Regards,

Zbigniew Sliwa
Oracle Programmer

Talar napisa³(a) w wiadomoœci: ...
>It worked, almost...
>column_position seemed to have been undefined.
>I need to order it by the columns and tried to look it up in manual.
>After i tried the descriptions from the dict table like you said but it
>returned a bit too much. Does column_id work for that?
>
>tia,
>Wil
>
Received on Fri Aug 04 2000 - 00:00:00 CDT