Re: Query runtime is slow in view

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: Amit Saroha <eramitsaroha@xxxxxxxxx>
  • Date: Thu, 4 Feb 2021 02:26:53 +0300

or you can just wrap it into scalar subquery ... = (select
fnd_profile.value('ORG_ID') from dual)
for scalar subquery caching

Other related posts: