Re: Oracle Analytical functions - Qn

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 11 Nov 2002 16:17:42 -0800
Message-ID: <130ba93a.0211111617.7f4a45ba_at_posting.google.com>


Do a "select * from v$option" and see if "OLAP Window Functions" is set to true. If not, then probably it was left out during the installation of ORACLE.

  • Jusung Yang

rejib_at_yahoo.com (Reji) wrote in message news:<ce0b2a83.0211111017.3aed7858_at_posting.google.com>...
> I am getting the following error when I issued the query "Feature not
> enabled OLAP Windows Functions"....what needs to be done here? I have
> oracle8.1.7 Enterprise edition.
>
> Reji
>
>
> JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0211100948.46add397_at_posting.google.com>...
> > The posting looks incomplete. ID2 does not seem to play a role in your query.
> > If so, a sum and a ratio_to_report should do it. Something like
> >
> > select ID, ratio_to_report(c1) over() from (
> > select ID, sum(bytes) c1 from <table_name> group by ID)
> >
> >
> > - Jusung Yang
> >
> >
> > select
> > rejib_at_yahoo.com (Reji) wrote in message news:<ce0b2a83.0211091330.4b444432_at_posting.google.com>...
> > > I have the following data set:
> > >
> > > ID ID2 BYTES
> > > 1000 1000 1000
> > > 1000 1200 2000
> > > 1000 1300 2000
> > > 1200 1400 5000
> > > 1200 1000 5000
> > > 1250 1400 5000
> > >
> > > Assume that ID and ID2 are two locations and BYTES - number of bytes
> > > transfered from ID to ID2
> > >
> > > I would like to produce couple of results
> > >
> > > 1) Shared percentage of data transfered from each ID
> > >
> > > Ex with this data set
> > >
> > > ID Shared percentage
> > > 1000 25% (5000/20000)*100
> > > 1200 50%
> > > 1250 25%
> > >
> > > I would like to use oracle analytical function if I can...please help
> > > me here
> > >
> > > RB
Received on Tue Nov 12 2002 - 01:17:42 CET

Original text of this message