Procedures or function using set command
Posted by:
Phil Siyam
Date: January 24, 2022 07:35AM
Hi,
We recently upgraded from 8.0.24 to 8.0.26. Any procedures or function using set command are very slow and we have been changing set to into. E.g
-- Old Query
set var_1 = (select col1 from tab1 where col2 = 11);
-- New Query
select col1 into var_1 from tab1 where col2 = 11;
Is there better way to do it?
Thanks in advance.
Subject
Views
Written By
Posted
Procedures or function using set command
914
January 24, 2022 07:35AM
371
January 24, 2022 09:18AM
362
January 25, 2022 07:15AM
343
January 25, 2022 03:20PM
397
January 27, 2022 04:17PM
340
January 27, 2022 04:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.