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: