code feat

 For large data inserts I can suggest you few things like: Use trigger(PL/SQL) Use APPEND hint Remove indexes on tables Firstly, while you use triggers in the table it could leave data to be logically corrupt. And it will then perform insert in a very conventional way. Which is a time consuming process and won’t helps us! Secondly, using APPEND hint will help us to an extend. So, APPEND hint tells the optimizer to perform a direct-insert into the table, which improves the performance. Now there is a way which we could achieve this by minimizing the Redo generation. What Redo do is; it basically ensures the recoverability of data to the database. It writes down every transaction to the archive log. Let’s take a scenario, where if the database is running on the NOARCHIVELOG mode, using APPEND hint will reduce the redo generation i.e; it won’t write into the archive log anymore and thus increases the speed. But then it won’t be able to recover at any point in time if your data is ambiguou

Indexes are used to retrieve data from the database in a very efficient and fast way. Here are the advantages and disadvantages of index on tables; Click on the link to know more:   Click here

To begin with, List Comprehension is an elegant and easiest way for creating list based on the existing list. It is also a compact and faster way of creating lists. Let’s look at some examples: Click on the link for more explanation:  Link to my Space