select [#]<item_list>
  into <variable_list>
  from <table_list>
 where <where_clause>;