Help for this page

Select Code to Download

Select or download this

my @company_ids = qw(10 15 20);    # for example
my $where = 'where company_id in (' . join(',', @company_ids) . ')';

...
from   companies
$where
END_SQL

Select or download this

$sql = <<END_OF_SQL;
    select comp_name
    from   companies
    where  company_id in ( @{[join(',', @company_ids)]} )
END_OF_SQL