Answer Posted / viswanath
To improve the performance of the application,oracle introduce bulk bind process using collections that is in this process we are putting all sql related vales into a collections.And in this collections we are performing insert,update at a time using for all these statements.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is join same as left join?
How does sql developer connect to oracle database?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What are the advantages of pl sql?
What are all types of user defined functions?
What is fmtonly in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Why coalesce is used in sql?
What has stored procedures in sql and how we can use it?
How many row comparison operators are used while working with a subquery?
How many sql statements are used?
What are all the different normalizations?
Is there a 64 bit version of ssms?
What is delimiter in pl sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com