Re: where clause filter from an array or use temp table?

From: Jared Still <>
Date: Tue, 30 Dec 2014 10:11:02 -0800
Message-ID: <>

On Thu, Dec 18, 2014 at 9:59 AM, Jeff C <> wrote:

> where emp_id in (select column_value from table(cast(t_numbers as
> num_tab)))

Have you tested this using a GTT rather than a huge where clause?

It would be much simpler, and more stable.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog Oracle Blog: Home Page:

Received on Tue Dec 30 2014 - 19:11:02 CET

Original text of this message