PL/SQL nested select problem.

From: Wladimir Melnikov <wlad.m_at_mailexcite.com>
Date: 11 Jun 1998 19:12:06 +0300
Message-ID: <01bd954b$b4795be0$01fdfddf@ser1>

Hello All!

Does anybody know why this cursor dont work:

	cursor q(some_param integer) is
 		select A.* from (select * from B where B.ID<some_param) where A.ID is

not NULL;

When I use nested select's is dynamic SQL - no problems.

        select b.* from B where B.ID<some_param and B.ID is not null - this improperly use indexes and very slow in huge tables.

        Please, email me.

        Regards , Wlad.M          Received on Thu Jun 11 1998 - 11:12:06 CDT