Hi all,

I have a developer using SQL Server's dynamic cursor which means after he opens the cursor, he can get committed changes made by anyone and uncommitted changes made by the him when he fetches the data the next time. i.e. after the cursor gets opened, the result set will be updated dynamically until the cursor get closed.

He wants me to find a counterpart in Oracle while I don't think there is an exact match. As far as I know, Oracle always maintain at least statement level read consistency, so once the cursor being opened, the result set will be static unless you open the cursor again. Is that right?

If that's correct, how can he compare the differenece between the result set when the cursor is opened and closed?

Thanks in advance for your reply...