RE: [External] : sqlplus set feedback ONLY questions when hitting 12.1 database
Date: Mon, 27 Jun 2022 18:07:02 +0000
Message-ID: <SJ0PR10MB4686751A1F5A449DF52ACAA4A3B99_at_SJ0PR10MB4686.namprd10.prod.outlook.com>
Go grab SQLcl…those are client side things, db version doesn’t matter.
[cid:image001.png_at_01D88A2F.2BD53A40]
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Chris Taylor
Sent: Monday, June 27, 2022 1:53 PM
So a Dev just sent me a query to work on where he's using SET FEEDBACK ONLY - so I had to look it up.
The problem is, he's using a 19c sqlplus client connected to a 12.1 database where FEEDBACK ONLY wasn't available.
So I'm curious and haven't traced it [yet] , doesn't anyone know what the database does in this case?
I'm imagining that in 12.1 it will skip the FETCH (because FEEDBACK ONLY wasn't available) whereas in 12.2 and above the database will perform the FETCH.
Does anyone know? (Before I trace it myself - I don't want to answer a question for myself that someone else already knows)
Chris
To: oracle-l_at_freelists.org
Subject: [External] : sqlplus set feedback ONLY questions when hitting 12.1 database
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 27 2022 - 20:07:02 CEST
