Write a SQL query to select only rows from a table where 2 columns together are distinct.
Posted on 2005-04-12
1) The first part of the question is, how do I write a SQL query to select only rows from a database table where 2 columns together are distinct?
2)Does anyone know if there is a way to save the results of the SELECT query & insert the rows a few at a time so that the order of the rows is preserved?
Once I have selected only rows where the 2 columns together are unique, I want to insert those rows into an Oracle database. I'm migrating data from Access to Oracle & inserting it by writing a utility in ColdFusion that does all of the Selects from Access & Inserts into Oracle. The problem is, when I do an insert, I keep getting an error in Oracle that says, "maximum number of cursors exceeded" & it stops inserting values half-way through. I have no control over the Oracle database, so my only option is to make this work through ColdFusion. Since the "maximum number of cursors exceeded" error only appears after inserting many rows, I figure if I can insert a few rows at a time then it will all be inserted.