Want to Insert Multiple Rows at a Time into DB Using Stored Procedure.
By: Sugandh | 15 May 2015 6:08 pm | 1220 times viewed | 0 Comments
I am having this query that i want to insert multiple rows at a time into db using stored procedure.
Could any one provide sample SP code snippet for insertion using V array concept?
Please help me out, thanks in advance.
No Comments Posted for this Article.
Top 10 Emerging and Highest Paid SAP Modules of USA for 2016It comes as no surprise that SAP stands at the number 3 position as per Forbes magazine in terms of the most admired software companies to work for in the United States of America. SAP has been proving time and again that their strategies are extremely state-of-the-art and offer progression to all...
Top Highest Paid Oil and Gas Companies Which Uses SAPWe all understand and would agree to the fact that a professional qualification like SAP does definitely give you an edge over the others apart from providing you with a good salary structure. There are quite a few modules available in SAP ( Systems, Applications, Products in Data Processing.)...
Important ABAP DATA DICTIONARY Interview QuestionsDATA DICTIONARYType of a table or structureThe table type determines how the logical table description defined in the ABAP/4 Dictionary is reproduced on the database. There are the following table types: transparent table structure append structureFor internal purposes, such as storing control...
Important SAP KEYBOARD SHORTCUTS ListSAP KEYBOARD SHORTCUTS Instead of an SAP icon button, you can use a keyboard shortcut. A keyboard shortcut is a key or combination of keys that you can use to access icon button functions while you are working in SAP. On a PC, the icon name and keyboard shortcut are displayed when you place the...
I Want to Export 15 million Rows into CSV.
Hello Experts, I have this scenario like I want to export 15 million rows into CSV. I tried using spool. CSV via sqlplus and only 65000 rows exported in one sheet in single CSV. What...
How to Use Cursor in A Loop?
Hello Experts,I want use ref cursor in a loop. Does any one have any example of those?Actually my requirement is to calculate avg of time taken for the process at each 10 min time interval.Lets say...
Do the Cursor Fetches all the Records at a time?
Hello Experts, Do the cursor fetches all the records at a time or one record at a time from the server. I know bulk collect throw all the records at a time and Pl/sql table bring only 1 record...
Any Way to Call sqlldr from Stored Procedure?
Hello Experts, Is there any way to call sqlldr from stored procedure, Because I am not interest in calling the shell script for invoking the sqlldr. Please assist here. Thanks in advance.
Error When Create a Procedure in user_objects;
Hello Experts, When we create a procedure in user_objects; where i am getting these below errors 1 create or replace procedure print_user_objects 2 is 3 cursor c_obj is select * from...