我如何使用C＃在Oracletable视图中插入 [英] How I Insert In Oracletable View Using C#

问题描述

你好，我有一个问题，我如何使用C＃插入全视图

hello i have 1 question how i insert in into full view using C#

"INSERT INTO SUB_CATEGORY_V(ID, CATEGORY_NAME , SUBCATEGORY_NAME, NOTE) " +
               "Values(SUB_CATEGORY_SEQ.nextval, '" + comboBox1 + "', '" + textBox1.Text + "', '" + richTextBox1.Text + "')";

这段代码给我的错误无法修改多个基表通过连接视图

this code is giving me error cannot modify more then one base table throught the join view

推荐答案

我建​​议不要在任何视图上调用insert。这是不好的做法。找到执行您要执行的操作的Oracle API，或者在表中插入要插入数据的oracle文档。看起来像您正在查看的视图与大多数视图一样，是一个或多个表的连接。我敢打赌，如果它的某些Oracle ERP功能有一个API。

I would advise against calling insert on any view. It is bad practice. Either find an Oracle API that does what you are trying to do, or read oracle documentation on the table in which to insert the data you are trying to insert. Seems like the view you're looking at as with most views, is a join of one or more tables. Its my bet that if its some Oracle ERP function that there is an API for it.

这篇关于我如何使用C＃在Oracletable视图中插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！