列出oracle中用户视图的列名 [英] List column name for user views in oracle

问题描述

查询列表中Oracle中用户创建的视图的列名是什么?

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

推荐答案

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

您还可以使用USER_TAB_COLUMNS和/或DBA_TAB_COLUMNS，具体取决于您的权限以及是否有权查询该视图.

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.

这篇关于列出oracle中用户视图的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！