Uwe Hesse in his article
Dropping a table during SELECT has described how dropping a table during select statement works in oracle database server. As per his post, you are able to drop while selecting from the table. In contrary to this in SQL server dropping a table while a select is running doesn't work. The drop statement is blocked by the select statement. Once the select statement is completed, the drop statement also completes.
Hi,
ReplyDeleteThanks for sharing the information with your users .Now oracle fusion and R12 are the main leading Topics in oracle. for more information check the link below.
Thank you.
oracle R12 training