Home » RDBMS Server » Server Utilities » Session
Session [message #72922] Sun, 14 December 2003 02:53 Go to next message
Imran
Messages: 56
Registered: November 2001
Member
I need to share information b/w sessions without commiting the data. Like if user-A executes query on dept 10 than i need to restrict other users to executing query on dept-10.

Imran

Report message to a moderator

Re: Session [message #72931 is a reply to message #72922] Wed, 17 December 2003 09:01 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Imran,
Queries do not read uncommitted data from other sessions.The default isolation level is READ COMMITTED. Also Readers do not block Readers.

-Thiru

Report message to a moderator

Previous Topic: Creating a table from another table
Next Topic: Multiple loading in SQL Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 01:54:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.