RE: ORACLE Statements in a PLSQL Block
- From: <rajendra.pande@xxxxxxx>
- To: <ric.van.dyke@xxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 24 Feb 2014 10:01:45 -0500
Thanks Rick
I was not able to do any testing and was intrigued by the fact that the
comments were removed
So I guess and as your review shows the "comments" for hints are not
really treated as comments :)
Regards
-----Original Message-----
From: Ric Van Dyke [mailto:ric.van.dyke@xxxxxxxxxx]
Sent: Monday, February 24, 2014 9:52 AM
To: Pande, Rajendra; Oracle-L@xxxxxxxxxxxxx
Subject: RE: ORACLE Statements in a PLSQL Block
OK I blogged on it too. See the full test here:
http://ricramblings.blogspot.com/2014/02/plsql-and-formating-of-sql-text
.html
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
rajendra.pande@xxxxxxx
Sent: Monday, February 24, 2014 9:12 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: ORACLE Statements in a PLSQL Block
Came across this MOS note
How to Determine the SQL_ID of a SQL Statement in a PL/SQL Block (Doc ID
741724.1)
As part of the note it goes on to say that
"The SQL statement within the PL/SQL block is actually stored
separately, but you cannot see it because:
* every sql statement in a PL/SQL block is stored as capital letters
* every comment and INTO clause are removed
If that is the case does it not have implications for the optimizer
related to performance and statement tuning. .. Given that all hints are
also removed
Wondering if someone has done some research and blogging on this topic
Regards
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
for important disclosures and information about our e-mail policies. For
your protection, please do not transmit orders or instructions by e-mail
or include account numbers, Social Security numbers, credit card
numbers, passwords, or other personal information.
--
//www.freelists.org/webpage/oracle-l
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
for important disclosures and information about our e-mail
policies. For your protection, please do not transmit orders
or instructions by e-mail or include account numbers, Social
Security numbers, credit card numbers, passwords, or other
personal information.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
