使用Concatenate的Oracle Update语句 [英] Oracle Update Statement using Concatenate
问题描述
大家好，
这是我在这里的第一篇文章。我阅读了指南，没有通过搜索找到任何相关内容，所以我想在这里提供一些帮助。
我试图在一个表上根据另外两个字段写一个更新语句表格到第三个连接表格。
表1有一个字段部分代码和一个主键（T1.partcode，T1.1PK）
表2有字段仓库代码和主键（T2.whcode，T2.2PK）
表3包含连接表1和表2的唯一信息，因此它看起来像这样：
T3.partcode-whcode，外键表示与T1和T2的记录关系。这就是我所拥有的：
Hi guys,
This is my first post out here. I read the guidelines, did not find anything relevant via searching, so I would like some help here.
I am trying to write an update statement on a table based on fields from two other tables to a third joined table.
Table 1 has a field part code and a primary key (T1.partcode, T1.1PK)
Table 2 has a field warehouse code and a primary key (T2.whcode, T2.2PK)
Table 3 hold unique information joining table 1 and table 2, so it looks like this:
T3.partcode-whcode with foreign keys indicating the record relationship to T1 and T2. Here''s what I have:
推荐答案
您是否遇到代码问题？
Are you facing any problem with the code ?
您是否遇到代码问题？
Are you facing any problem with the code ?
感谢您的回复。是的，这个声明不适用于Oracle。我想知道如何重新编写代码以将字段更新为两个源字段和短划线的连接。
我的问题实际上是表链接以及如何告诉Oracle我的来自不同表格的源字段而不是正在更新的表格。
再次感谢，
Derek
Thanks for your reply. Yes, this statement won''t work with Oracle. I am wondering how to rework the code to update the field to a concatenate for the two source fields combined with a dash.
My problem is really the table linking and how to tell Oracle my source fields from different tables than the table being updated.
Thanks again,
Derek
我找不到任何理由为什么代码在oracle中不起作用。
I can''t find any reason why the code will not work in oracle.
这篇关于使用Concatenate的Oracle Update语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
