How to check for values in array?

i stored some values in array , then i traverse through the array and check for
some values and if they exist then echo success.
let us consider that in our array we stored values from an sql query

like this

#!/bin/bash
declare -a arr
arr=$( sqlplus -s rte/rted2@rel76d2 << EOF
set heading off
select source_id from (select * from cvt_istats order by 1 desc) where rownum <= 5;
exit
EOF
)

now i have to check this arr that whether 1 , 2, 3 are present in this or not

so what can i do. please help

This will not fill your array. Try:

arr=( $( ...
...
) )