Shell Programming and Scripting

SELECT ABC,
DEF
WHERE (XYZ = 'Normalization' or 
ABC_TYPE = 'DEF') and lookup_port like 'ABAC%'

if ( $qry =~ m/(where.*)/i)
{
print $1;
}

WHERE (XYZ = 'Normalization' or 
ABC_TYPE = 'DEF') and lookup_port like 'ABAC%'

$qry =~ s/\n/ /g;

ABC_TYPE = 'DEF') and lookup_port like 'ABAC%'

/(where[\s\S]*)/i

$1=~s/\n//;

skrynesaver@busybox~$ perl -e ' my $string="This is line one
this line two
and this is the end of the string";print "$1\n" if $string=~/is line(.*)/;'
 one
skrynesaver@busybox~$ perl -e ' my $string="This is line one
this line two
and this is the end of the string";print "$1\n" if $string=~/is line(.*)/s;'
 one
this line two
and this is the end of the string