How to enter more data in a query using TOAD ???

[manisekar]

HERE IS THE QUERY ....

SELECT TAB111_ID
FROM TAB222, TAB111
WHERE TAB111_PIDM = TAB222_PIDM
AND TAB111_CHANGE_IND IS NULL
AND TAB222_SSN IN ('040402918',
'040501664',
'040866813',
'041407563',
'041485615',
'041606120',
'041708444',
'041768392',
'041780596')

In the above query, the TAB222_SSN gives me the respective TAB111_ID . But i am restricted to 999 only. Once i have to use more , i have to use OR statement. But i like to know whether any one can help me to retrieve 40k data, in a simple way.

thanks,
Mani.