Re: name of columns

Abiy Alemu <abiy_at_biotec.jouy.inra.fr> wrote:

>Is there any method to select the name of the colums of a table, either
>in sql or plsql ? Something like
> select columns from <table_object>
> where table_name = <table_name>
>?????
 

>|-----------------------------------------------------------------------------|
>| If the only tool you have is a | Abiy Alemu abiy_at_biotec.jouy.inra.fr |
>| hammer, everything in the world | 9, avenue calmels |
>| seems like a nail.____________________| 92270 Bois colombes (France)________|

Try this:
select column_name
from all_tab_columns
where table_name=<table_name>
order by column_id

This should give you the column names. You can also get more data like type & size of the columns from this table.

Co Veenstra
c.veenstra_at_ptt-telecom.unisource.nl

     This statement is not an official statement from, nor does
      it represent an official position of, PTT Telecom BV.

------------------------------------------------------------------------