Re: Return rows as 1 line?
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 18 May 2010 18:58:03 -0700 (PDT)
Message-ID: <e0270b20-cdd7-4d63-8229-af2781ae7fb4_at_a20g2000vbc.googlegroups.com>
On May 18, 7:59 pm, galen_bo..._at_yahoo.com wrote:
> But the question should just be, where is the most performant place to
> do this. Who gives a hoot if you add non-relational functional to the
> database to get a job done?
Date: Tue, 18 May 2010 18:58:03 -0700 (PDT)
Message-ID: <e0270b20-cdd7-4d63-8229-af2781ae7fb4_at_a20g2000vbc.googlegroups.com>
On May 18, 7:59 pm, galen_bo..._at_yahoo.com wrote:
> But the question should just be, where is the most performant place to
> do this. Who gives a hoot if you add non-relational functional to the
> database to get a job done?
Our corporate controller. A developer of ours found this function on asktom and cut and pasted it into the application. Voila...instant CPU spike on the server whenever the query is run. If more than one session runs it? Geez, alarms start firing everywhere.
In our case, it made more sense to have a procedure return a cursor to the application and then build up the string in java (which is free). Received on Tue May 18 2010 - 20:58:03 CDT