how i select columns names from any table

[aatish19]

Hi all,

i want to fetch columns names from my table using pl/sql

what view i can use??

[debasisdas]

1.You need to use the dictionary object USER_TAB_COLS.
2.Pass the table name.
3.Use cursor to fetch the coumn name.

[Pilgrim333]

Hi,

You can use a sql qeury in your pl/sql procedure

Pilgrim.

[edit] my bad, didn't read that well :D what the post above said

[aatish19]

1.You need to use the dictionary object USER_TAB_COLS.
2.Pass the table name.
3.Use cursor to fetch the coumn name.

Thanks dear...

Kashif Arain

[debasisdas]

you are always welcome buddy.