Oracle查询备注信息

<strong>查询字段的备注信息：<br></strong>

<span style="color: #0000ff;">SELECT</span><span style="color: #000000;">
    TABLE_NAME,
    COLUMN_NAME,
    COMMENTS
</span><span style="color: #0000ff;">FROM</span><span style="color: #000000;">
    USER_COL_COMMENTS
</span><span style="color: #0000ff;">WHERE</span><span style="color: #000000;">
    TABLE_NAME </span><span style="color: #808080;">=</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">SFA_STOCK_REQUEST</span><span style="color: #ff0000;">‘</span>

<strong> </strong>

Oracle查询备注信息

标签：