oracle12c 给视图
时间: 2023-09-02 19:08:05 浏览: 57
回答: 在Oracle 12c中,可以使用内联视图来解决问题。通过将内联视图放在查询的FROM子句中,并使用INNER JOIN将其与其他表连接,可以确保首先评估内联视图。例如,可以使用以下查询来创建一个内联视图并将其与表b连接:
select x from b inner join (
select only_rows_with_numeric_values as numeric_column
from a
where NOT REGEXP_LIKE (a.column, '\[^\[:digit:\]\]')
) c on c.numeric_column = b.numeric_column;
这样,内联视图中的查询将首先执行,并将结果与表b进行连接。这样可以确保在查询过程中首先评估内联视图。\[1\]
#### 引用[.reference_title]
- *1* [Oracle 12c内联视图评估](https://blog.csdn.net/weixin_36179933/article/details/116360190)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [12c 物化视图 - 对快速刷新的理解](https://blog.csdn.net/weixin_28716443/article/details/116289395)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [oracle12c v$sql视图字段全解](https://blog.csdn.net/weixin_26804345/article/details/116522206)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]