Re: Select * and column names

A nasty detail. In some dictionary views it is column_position, in some column_id. I pointed you to dict to enable you to find out more about the dictionary. To see the definition of all_tab_columns (as of all tables and views) simply do a describe <table_name>

Hth,

Sybrand Bakker, Oracle DBA

"Talar" <talar_at_deja.com> wrote in message news:qpli5.80279$ou1.430297_at_nlnews00.chello.com...
> 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