or replace

"or replace"是在创建或修改视图时使用的关键词。当使用"create or replace"语句创建视图时，如果该视图已经存在，则会先删除原有的视图，然后再创建新的视图。如果该视图不存在，则会直接创建新的视图。这样可以确保视图的定义始终是最新的。同样，当使用"alter view"语句修改视图时，也可以使用"or replace"关键词来替换旧的视图定义。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Oracle学习第二天](https://blog.csdn.net/guanghuotainkong/article/details/115643631)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [MySQL -＞ TCL:创建视图(view),调用视图,修改视图(or replace,alter),删除视图(drop),查看视图(desc)](https://blog.csdn.net/rod0320/article/details/109578372)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]