As certain southern sportsmen often say, "My bad." It wasn't the explain statement
but the program which builds them. Work done at 1:30 AM is always suspect.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 24, 2002 10:09 A
Oracle Apps r10.7 and r11.0 had some SQL statements from PRO*C batch
programs that are over 20K in length. Utterly astounding!
Since VARCHAR2 variables can be up to 32767 in PL/SQL, I've written PL/SQL
packages that used string variables of that length for automating EXPLAIN
PLAN execution and s
Ian:
Any valid SQL statement can be explained. I've explained queries that were
well over 4k -- even when you excluded the whitespace!
Kevin
-Original Message-
Sent: Wednesday, July 24, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L
What is the longest SQL statement that can b
What is the longest SQL statement that can be analyzed via explain plan. Is it the
maximum length equal to the maximum length of a varchar2. Does the new virtual
explain view have any problems with the length of the statement?
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED