Re: Fine points on analytic functions

From: Jared Still <jkstill_at_gmail.com>
Date: 2 Nov 2004 11:20:15 -0800
Message-ID: <bf4638.0411021120.5ef1652@posting.google.com>

You would get a lot further here if you provided DDL to create test data that is representative of your real data.

This looks like an interesting challenge, but not many folks are inclined to invent test data for someone else's problem. :)

Also, is this a custom app? If so, you need to do something about encoding information in the length of the data.

Jared

dba_222_at_yahoo.com (Roger Redford) wrote in message news:<a8c29269.0410270826.4b1df9af_at_posting.google.com>...
> Dear experts,
>
> I have a complex report to create, and I'm wondering if
> analytic functions can help me. I'm a newbie with them,
> and I've been having some success, but I'm not sure if they
> can help me here or not.
>
> There are two tables in a standard 1:M relationship.
> Let's call the main table the master table. The
> many table is let's say, master_history. In master_history,
> we keep a log of all activity with the master table.
>

... Received on Tue Nov 02 2004 - 13:20:15 CST