my $sth = $dbh->prepare("SELECT name from employee where empno= ?"); $sth->execute($empno->{empno}); my $emp= $sth->fetchrow;
$sth->execute(); my $name = $sth->fetchrow;