Toad World® Forums

SQL Statement comparing with collections


#1

Hello,

is it possible to compare a sql statement that contains a collection of record

for example

select name from emp;

ABC
DEF
XYZ

contains collection

collection(1):=‘ABC’;
collection(2):=‘DEF’;


#2

I am sorry, I do not understand the question. Your query does not contain a collection of anything. It returns a single name. Does your program select these names into a collection? Do you want to test the contents of the collection?

Please clarify…

SF


#3

I am sorry i was not clear enough with my question, i have solved my issue, thanks for your reply