oracle - 如何从 oracle DB 的元数据中获取表和列的注释？

Question

我正在开发一个 Java 应用程序。我已使用 JDBC Connection 连接到 Oracle DB 并获取它的元数据。我从它的元数据中获取表、列、 View 等信息。

现在我想从元数据中分别获取应用程序中表和列的评论。
我怎样才能获取这些详细信息？

Answer 1

Now I want to fetch Comments for tables and columns separately in the application from metadata. How can I fetch this details?

对于 表评论 , 使用 [DBA|ALL|USER]_TAB_COMMENTS看法。

例子:

SQL> SELECT table_name,
  2    comments
  3  FROM dba_tab_comments
  4  WHERE owner   ='OE'
  5  AND table_name='INVENTORIES';

TABLE_NAME  COMMENTS
----------- ---------------------------------------------------------------
INVENTORIES Tracks availability of products by product_it and warehouse_id.

对于 栏目评论 , 使用 [DBA|ALL|USER]_COL_COMMENTS看法。

SQL> SELECT table_name,
  2    column_name,
  3    comments
  4  FROM dba_col_comments
  5  WHERE owner   ='OE'
  6  AND table_name='INVENTORIES';

TABLE_NAME  COLUMN_NAME          COMMENTS
----------- -------------------- ----------------------------------------------------------------------------
INVENTORIES PRODUCT_ID           Part of concatenated primary key, references product_information.product_id.
INVENTORIES WAREHOUSE_ID         Part of concatenated primary key, references warehouses.warehouse_id.
INVENTORIES QUANTITY_ON_HAND