dml single insert/select or bulk collect/forall

Author: asktom.oracle.com | Published: 9th Apr 2008 | Visited: 58 times | Add Comment
Filed in: Oracle FAQ

Tom, i am currently designing a new database 10g Rel2 and would appreciate your advice on the following Which method would you advise for the following business process OPTION 1 ######## DECLARE CURSOR c1 IS SELECT ..............

Read Article

Sponsored Links

• RESTRICT USERS TO INSERT/UPDATE DATA EXCEPT THEIR PRIVILIEGES DEAR TOM i learn a lot from this platform as a new dba i have a situation here. i did't write code/script here because i havn't any idea that how i ask from you? i have tried to convey my.. i have a database of almost 60 tables. application d ...

• LINQ TO SQL All Common Operations (Insert,Update,Delete,Get) in ONE BASE Class Base Class to perform all Common LINQ To SQL Operat ...

• Bulk Insert using ODP.NET Bulk Insert using ODP ...

• Using A Single Transaction With Multiple Typed DataSets Provides a detailed explanation of how to implement a single transaction across multiple Typed Data ...

• Select Which Panel Displays AutoHint in Delphi's TStatusBar in Delphi TIPS :: The TStatusBar Delphi control displays a row of panels, usually aligned at the bottom of a form. When AutoHint is true, the status bar automaticall ...

• Using the SelectDirectory Delphi routine - to Select a Directory/Folder in Delphi TIPS :: You can display a dialog to the user to allow directory/folder selection without using a TOpenDialog component. First, add FileCtrl unit to the uses clause o ...

• Connect Multiple UI Elements to a Single Command Object An easy way to group several UI elements (menu items, toolbar buttons, etc.) so they all execute the same command and are enabled/disabled together (with Visual Studio designer suppo ...

• CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final out ...

• ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter In the previous example, we worked with a set of rows in the DataTable object. Now, we shall work with a particular row using the DataTable object. The following code accepts an employee number from the user and gives you the. ...

• ODP.NET - Populating a Dataset with a Single Data Table ODP.NET - Populating a Dataset with a Single Data Table A dataset is simply a group of data tables. These data tables can be identified with their own unique names within a dataset. You can also add relations between data tables available in a dataset. Visit http://www.exforsys.com to read complete ...

Next: Indexes on single Partition of the table