i will query the database (for instance consider employees table )
for empno,ename,job,salary fields.The query returns me some 100 of rows. now i need to place them in a file in row wise pattern as they exist in the database.
now , if any row is updated in the database i need to update the same row in the file . also if any row is deleted i need to remove the same row in the file , and if any new row is inserted into the data base i need to insert the row in the file.
can any one suggest me any method to do this .
The performance is and main criteria(i mean time to do file operations. )
I actually made the mistake of giving him working Pro*C code - another forum. He did not seem to get that it worked. But it wasn't exactly what he specified, because his requirements are non-sequitur in a production world.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.