Question Locked

list all theColumn name of a table

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi,

i am using oracle 10g express to develop the applicton.i am looking the answer for retrieving all the column name of a particular table in oracle.

2 replies

by tony hopkinson

On the application side.
Select * from mytable where 1 = 0
then iterate through through the columns in the result.
Meta data wise
select c.name from syscolumns c, sysobjects o
Where c.id = o.id
and o.name = 'TableName'

This discussion is closed to new replies.