Friday 7 May 2010

Dropping a table during SELECT in oracle and SQL server

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.

1 comment:

  1. Hi,
    Thanks 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

    ReplyDelete