SQL & PL/SQL

Hi,

I have a table that contains several names like along with some other information.

alpha1
alpha2
beta2
gamma1
gamma2
...

I wanted to know about some of these entries, so I did a select like this.

select * from t
where t.name in ( 'alpha1', alpha2', 'beta1', beta2', 'gamma1', gamma2')

Now if you look at the data above you will see that beta1 is missing, so obviously the above query does not fetch information about beta1.

Is there a way to find the missing entries like this through SQL.

I have a restriction here. I have a readonly access to the database. I log in as schema2 and look at data in schema1. Moreover since this is a production database, I would not like to create any temporary tables in schema2 either. So, any solution has to use only select statements and no DML/DDL.

Thanks in advance,
Rajesh