hi, i want to select total count of records of table into variable. so how can i do that using select query? select count(*) into variable from table ; is this correct way???? thanx,