使用 PL/SQL 关联数组
create or replace aArr is TABLE of varchar2 index by binary_integer;
create or replace bArr is TABLE of varchar2 index by binary_integer;
create or replace prc(oname aArr, iname bArr) as
begin
--Now i have two arrays
-- i want to insert or update into table using these two arrays
-- How can i do that with out using the loops.
-- is there any bulk insert or update.
end
现在我有两个数组。我想使用这两个数组插入或更新表。我怎样才能在不使用循环的情况下做到这一点？是否有批量插入或更新？
create or replace aArr is TABLE of varchar2 index by binary_integer;
create or replace bArr is TABLE of varchar2 index by binary_integer;
create or replace prc(oname aArr, iname bArr) as
begin
--Now i have two arrays
-- i want to insert or update into table using these two arrays
-- How can i do that with out using the loops.
-- is there any bulk insert or update.
end
Now I have two arrays. I want to insert or update into table using these two arrays. How can I do that with out using the loops? Is there any bulk insert or update?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您有 PL/SQL 关联数组，则可以使用批量处理，使用 FORALL 将数据插入到基础数据库表中。
oracle 文档在这里：
http://download.oracle.com/docs/cd /B19306_01/appdev.102/b14261/forall_statement.htm
类似于：
语法 有点笼统的答案，但你问了一个非常笼统的问题。
希望这有帮助...
If you have PL/SQL associative arrays, you can use bulk processing to insert the data into underlying database tables using FORALL.
The oracle documantation is here:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/forall_statement.htm
The syntax is similar to:
It's a bit of a generic answer but you have asked a very generic question.
Hope this helps...