casey.kirkpatrick_at_gmail.com wrote:
> In Oracle 9i:
>
> I have a table with 50 rows marked as "Sent" and 50 rows marked as
> "Unsent". I have an outbound that must summarize the 50 "Unsent" rows
> (e.g. into 5 lines on a file), then update the 50 "Unsent" rows to
> "Sent" as one LUW. The summarization involves joining to other tables,
> applying WHERE clauses, and formatting of aggregate results.
I have a strong preference for students that try it all ways, benchmark
their results, and choose the one that performed the best.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 06 2005 - 13:07:06 CDT
