存储过程insert
时间: 2023-10-13 13:00:56 浏览: 91
回答: 引用中提到了一种存储过程,可以根据传入的表名生成数据的插入语句。这个存储过程接受四个IN参数,并将它们插入到名为"DBUSER"的表中。这个存储过程的代码如下:
CREATE OR REPLACE PROCEDURE insertDBUSER(
p_userid IN DBUSER.USER_ID%TYPE,
p_username IN DBUSER.USERNAME%TYPE,
p_createdby IN DBUSER.CREATED_BY%TYPE,
p_date IN DBUSER.CREATED_DATE%TYPE
) IS
BEGIN
INSERT INTO DBUSER ("USER_ID", "USERNAME", "CREATED_BY", "CREATED_DATE")
VALUES (p_userid, p_username, p_createdby, p_date);
COMMIT;
END;
/
然而,引用中展示的存储过程似乎是不完整的,无法提供完整的答案。请提供更多信息,以便我能更好地回答您的问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [SQL Server存储过程生成insert语句实例](https://blog.csdn.net/cxu123321/article/details/105706919)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [Oracle存储过程INSERT示例](https://blog.csdn.net/cyan20115/article/details/106551659)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文