I read the little blurb in the 9i new features on it. The example there doesnt seem
very useful. What have people used it for?
any good articles with good examples on this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Ryan,
I use it extensively ... for some of the utilities I wrote for application support ...
here is one sample ...
This utility shows errors in the pl/sql code, what's different is not only it shows
the errors, but also shows the source lines and exact location of the error.
To test, install
Subject
anyone use pipelined functions?
I read the little blurb in the 9i new features on it. The example there
doesnt seem very useful. What have people used it for?
any good articles with good examples on this?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
by: [EMAIL PROTECTED]
12/31/2003 09:04 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: anyone use pipelined functions?
I recently rewrote a poor-performing data load procedure (with single row
inserts, commit batches
[EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes, and a breakdown of the
the benefits of each
PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes, and a breakdown of the
the benefits of each would
:
Subject:Re: anyone use pipelined functions?
In the interests of documentation, and if I have time, I could engineer a
similar 'dumb' procedure, perform trace as each modification is made, and
post the results here. It's pretty easy to come up with an artificial
routine, though, to do
recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
Fantastic results Adam.
You didn't perhaps do interim testing did you, so that you
know how much of the benefit was due to the pipelined functions?
You made quite a few changes
]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
That would be cool if you have time for it.
Re the sequence: is it assigned in a trigger, or directly in the SQL?
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:19
My responses below are below
Ryan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 11:54 AM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
great response. questions inline
My responses below are below -- sigh, it's been a long day. lol
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/31/2003 01:59 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
Re: anyone use pipelined functions?
My responses
11 matches
Mail list logo