getting column Heading names in oracle database

Question

Please help me in this consider a table in oracle Database

SNo Name password
------------------
1    x    1234
2    y    2314

A query to fetch the headings such as SNO NAME PASSWORD

Gurwinder Singh · Accepted Answer · 2017-03-02T18:58:42.163

2

Query user_tab_columns (or all_tab_columns) to get the column names:

select column_name
from user_tab_columns
where table_name = 'YOUR_TABLE_NAME';

Replace YOUR_TABLE_NAME with your actual table name.

edited Mar 02 '17 at 18:58

answered Mar 02 '17 at 18:40

Gurwinder Singh

can you please elaborate little bit about user_tab_columns – raghu ram Mar 02 '17 at 18:56
@raghuram - Added a link for you. – Gurwinder Singh Mar 02 '17 at 18:58
i didnt get output i got a blank space . i just would like to know what can i add at user_tab_columns – raghu ram Mar 02 '17 at 18:58
@raghuram - Replace YOUR_TABLE_NAME with your actual table name. – Gurwinder Singh Mar 02 '17 at 18:58
I'm using a custom user, so in my case was needed to change "user_tab_columns" to "all_tab_columns" but this awnser help me alot – Theotonio Apr 19 '18 at 18:29

1 Answers1