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
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...