select [#]<item_list>
  into <variable_list>
  from <table_name>
 where <where_clause> 
   for update nowait;