Hi,
How could I SELECT all of the records from uncommited view? I need to do this because I want to check the existence of records in the view. That will be more than one record. I tired to use SELECT ....WHERE myKey NOT IN (SELECT myKey FROM myview).. but the subquery always return EMPTY record.

Any ideas?

Thank you