Re: [Oracle 8i Enterprise Edition] Which package do I need to install to get the analytic functions?

For Oracle8i:

If you are running EE, they should be there.

But, you can NOT use them in PL/SQL. The PL/SQL compiler does not recognize them. You CAN use them in views. So, create a view and use that view in your PL/SQL code.

Luc

"Jacques-Henri" <nobody_at_nowhere.com> wrote in message news:ca27pi$an8$1_at_s1.read.news.oleane.net...
> I need to install the OLAP functions (DENSE_RANK, etc.) on an Oracle 8.1.7
> server. Disk space is tight so I just can't install everything and I have
> absolutely no clue about which package I need.
>
> Oh, and don't tell me 'Upgrade to 9i' please ;-) That's not an option, and
I
> know these functions were introduced in the 8.1.6 release.
>
>
> TIA
>
>
>
Received on Mon Jun 07 2004 - 16:18:14 CDT