What you need to tell your developers is that if they want to emulate how a query will work in an outside environment, then they need to use F5 because that’s going to mimic that behavior
F9 is designed to give you a small subsection of your output in grid format. It’s not designed to give you the entire data set at once. F5 (and SQL*Plus) also has to allocate enough memory to accommodate the maximum amount of data for a row. If you have a bunch of VARCAR2(4000) columns, that total amount of space has to be allocated. F9 optimizes that as much as possible.
F9 - designed to get data as quickly as possible into the IDE grid
F5 - SQL*Plus and outside app emulation.
They are designed for different purposes so in your case, you need to tell the devs to use correct tool for the job that they’re trying to accomplish. Yes it’s called script execution but it’s also the way external apps are going to behave.
From: techsupport_93676 email@example.com
Reply-To: "firstname.lastname@example.org" email@example.com
Date: Monday, January 29, 2018 at 8:50 AM
To: "firstname.lastname@example.org" email@example.com
Subject: RE: [Toad for Oracle - Discussion Forum] Different behaviour in TOAD than in SQLPlus?
** RE: Different behaviour in TOAD than in SQLPlus?**
Reply by techsupport_93676
Gregory, that’s going in circles. The question is WHY does the same statement, with the same bind variables, perform vastly different in TOAD when executed as a query, compared to when executed as a script (or when executed outside of TOAD)? There has to be a logical explanation for this, it’s not magic.
I can’t go and tell 20 developers “from now on, only run your queries with F5”. They’re not going to do it, because 99% of the time you need to actually be able to actually read the output. Script execution via F5 is for running scripts (e.g. a series of update statements), it’s not optimal for working with a single select statement.
To reply, please reply-all to this email.
Stop receiving emails
on this subject.
Or Unsubscribe from Toad for Oracle Forum
Toad for Oracle - Discussion Forum
this post as spam/abuse.