I am working on a legacy system which uses Oracle database. Please dont ask me why data is stored the way it is :), there is a table ofsd_temp which has a varchar2 column entity_nums which has string of numbers separatedby pipe delimiter
e.g.

I have two sizable (~1M rows each) Oracle tables that I need to join on a range of integers. For example,