anyone use pipelined functions?

2003-12-31 Thread ryan_oracle
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]

RE: anyone use pipelined functions?

2003-12-31 Thread Jamadagni, Rajendra
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

Re: anyone use pipelined functions?

2003-12-31 Thread AdamDonahue
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

Re: anyone use pipelined functions?

2003-12-31 Thread Jared . Still
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

Re: anyone use pipelined functions?

2003-12-31 Thread AdamDonahue
[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

Re: anyone use pipelined functions?

2003-12-31 Thread AdamDonahue
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

Re: anyone use pipelined functions?

2003-12-31 Thread Jared . Still
: 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

Re: anyone use pipelined functions?

2003-12-31 Thread Ryan
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

Re: anyone use pipelined functions?

2003-12-31 Thread AdamDonahue
] 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

Re: anyone use pipelined functions?

2003-12-31 Thread AdamDonahue
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

Re: anyone use pipelined functions?

2003-12-31 Thread AdamDonahue
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