Forum Stats

  • 3,827,861 Users
  • 2,260,833 Discussions
  • 7,897,399 Comments

Discussions

Oracle sql query

user8656468
user8656468 Member Posts: 1 Green Ribbon

Hi ,

Would like to know if Oracle DB will evaluate the value for complete records undergoing row based extract.

eg

select a.*, (select b.code from b where b.type='XYZ')

from a

where rownum between 1 and 20;


Will oracle work internally to build b column value only for 20 records ?


Regards,

AS