List column name for user views in oracle

Question

What is the Query for list the column names for user created views in Oracle?

http://stackoverflow.com/questions/452464/how-can-i-get-column-names-from-a-table — rahularyansharma, Oct 21 '11 at 04:39

Justin Cave · Accepted Answer · 2018-11-16T23:00:55.523

40

SELECT
      table_name,
      column_name,
      data_type
 FROM all_tab_columns
WHERE table_name = 'VIEWNAME'
  AND owner      = 'OWNER'
ORDER BY column_id

You can also use USER_TAB_COLUMNS and/or DBA_TAB_COLUMNS depending on your privileges and whether you have permission to query the view.

edited Nov 16 '18 at 23:00

answered Oct 21 '11 at 04:33

Justin Cave

227,342
24
367
384

5

Below query worked fine SELECT TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME LIKE 'View Name' – Navaneethan Oct 21 '11 at 05:35
This also works for materialized views, is it worth to mention it in the answer? – mcvkr Aug 28 '17 at 20:56

score 8 · Answer 2 · answered Jun 20 '14 at 14:36

8

SELECT
    *
FROM
    ALL_TAB_COLUMNS
WHERE
    TABLE_NAME = 'your_view_name'

answered Jun 20 '14 at 14:36

Geo

12,666
4
40
55

score 2 · Answer 3 · answered Oct 21 '11 at 04:38

2

SELECT table_name, column_name, data_type, data_length
FROM USER_TAB_COLUMNS
WHERE table_name = 'MYTABLE'

answered Oct 21 '11 at 04:38

rahularyansharma

11,156
18
79
135

List column name for user views in oracle

3 Answers3

Linked