Get list of all Field Names in ORACLE DB

[SteveThePilot]

I'm wondering if there is a way I can list all of the field names in an Oracle table easily? Any ideas?

[jdeline]

If you SELECT * FROM tableName WHERE id = (SELECT Max(id) AS maxId FROM
tableName), you will have a variable named Foo.ColumnList, where Foo is the
name of your query. This is a comma delimited list of all fields in the table

[paross1]

Depends on your particular privileges in regards to your data dictionary, but....

SELECT column_name
FROM user_tab_cols
WHERE table_name=UPPER('YOUR_TABLE_NAME')

Phil

[BON]

select table_name, column_name from all_tab_columns where table_name like 'EMP'

[Unregistered]

depends on your particular privileges in regards to your data dictionary, but....

Select column_name
from user_tab_cols
where table_name=upper('your_table_name')

phil

brilliant !

[Unregistered]

Select fieldname from psrecfielddefn where recname like 'YourTableName'

[Unregistered]

select table_name, column_name from all_tab_columns where table_name like 'EMP'

Awesome it helped!