manually lock a record?

Hi all,

Is it possible to manually lock a record in oracle7/8. That is do a SELECT ... exclusivly lock the results. If so whats the SQL syntax. The closest I could find was LOCK TABLE. Also how does the unlock work?

Thanks

Mark

--

		       Mark  Ayzenshteyn      
        		marka_at_bonzo.org
  		  http://www.bonzo.org/~marka