Select Code to Download

 my $deptno = 20;
 my $sql = 'SELECT * FROM emp WHERE deptno = ?';
 my $sth = $dbh->prepare( $sql );
 $sth->execute( $deptno );
 ...