ORA-30926: unable to get a stable set of rows in the source tables
来源:互联网 发布:照片底色修改软件 编辑:程序博客网 时间:2024/06/07 11:05
SQL> Merge into tmp_mt p
2 using mt_kh np
3 on (p.mtname = np.mtname)
4 When matched then
5 update set p.mtjj = np.mtjj;
Merge into tmp_mt p
using mt_kh np
on (p.mtname = np.mtname)
When matched then
update set p.mtjj = np.mtjj
ORA-30926: unable to get a stable set of rows in the source tables
需要确保np.mtname的唯一性,否则会报错
- ORA-30926: unable to get a stable set of rows in the source tables
- ORA-30926: unable to get a stable set of rows in the source tables
- ORA-30926: unable to get a stable set of rows in the source tables
- ORACLE MERGE INTO语句,unable to get a stable set of rows in the source tables报错解决
- get all rows count of all tables in a mysql database.
- How to get the HTML source of a webpage in Ruby
- 转:How to submit the rows of a repeating table in InfoPath to a SharePoint list
- Get the rows count of all the table in Sybase
- a method to set the title of webpart in code
- vmware vcenter converter 4 FAILED: Unable to create a VSS snapshot of the source volume(s)
- How to get the tables of one schema?
- How to provide the capability to expand empty rows of a master view to be able to add child rows
- how to get the space size of some tables in one database?
- How to get request_id of previous request in a request set?
- How to get a notification from Linux when the set of network interfaces changes
- How to set the ListView Rows Height
- How to Get the Frequency Table of a Categorical Variable as a Data Frame in R
- A guide to get you building OGRE from source with the default settings in the shortest possible time
- VC多线程编程实例
- C语言实现累加和累乘
- Linux文件类型与扩展名
- ios+html更新策略
- CPropertySheet和CPropertyPage中数据交换时的两种处理手段
- ORA-30926: unable to get a stable set of rows in the source tables
- 中国象棋程序的设计与实现(十一)--第2次回答CSDN读者的一些问题
- 企业青睐什么样的产品经理
- { }soj1308
- ios开发启动页面
- (DS1.5.10)POJ 1019 Number Sequence(确定一个数字序列中某一个位置上的数字)
- discuz 转换nginx服务器后 url重写规则
- PHP POST数组有上限? max_input_vars!
- 用VB快速读取TextBox第N行的数据