Home » SQL & PL/SQL » SQL & PL/SQL » grouping function (Oracle10g,Linux)
grouping function [message #342362] Fri, 22 August 2008 02:35 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

Is any difference between grouping function in oracle9i and oracle19g?


Thanks,
Michael.
Re: grouping function [message #342363 is a reply to message #342362] Fri, 22 August 2008 02:46 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
oracle19g?

Is this available in market??

Regards,
Rajat
Re: grouping function [message #342364 is a reply to message #342362] Fri, 22 August 2008 02:50 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
As far as I know, Grouping(..) works the same in 9i and 10g.

Do you have reason to believe differently?
Re: grouping function [message #342368 is a reply to message #342362] Fri, 22 August 2008 02:53 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

Look into this

http://www.remote-dba.net/pl_sql/t_sql_grouping.htm
Re: grouping function [message #342369 is a reply to message #342364] Fri, 22 August 2008 02:54 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Oracle9i SQL Reference Release 2 (9.2) Grouping

OracleŽ Database SQL Reference 10g Release 2 (10.2) Grouping
Re: grouping function [message #342375 is a reply to message #342362] Fri, 22 August 2008 03:24 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
In addition, new SQL features in 10gR2 are listed in
OracleŽ Database SQL Reference 10g Release 2 (10.2) What's New in the SQL Reference?
Re: grouping function [message #342376 is a reply to message #342362] Fri, 22 August 2008 03:24 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I am executed the query with grouping function in oracle10g it shows a ORA-03001: unimplemented feature but the same query works in oracle9i.
so that only i am asking the above question


Thanks
Michael.
Re: grouping function [message #342377 is a reply to message #342376] Fri, 22 August 2008 03:34 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

holdingbe wrote on Fri, 22 August 2008 10:24
Hi,

I am executed the query with grouping function in oracle10g it shows a ORA-03001: unimplemented feature but the same query works in oracle9i.
so that only i am asking the above question


Thanks
Michael.


What query ? We cant't see your screen

Re: grouping function [message #342380 is a reply to message #342376] Fri, 22 August 2008 03:39 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Are you using 10g Standard or Enterprise?

Without more information, there's not a lot we can do.
Re: grouping function [message #342384 is a reply to message #342376] Fri, 22 August 2008 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-03001: unimplemented feature
 *Cause:  This feature is not implemented.
 *Action:  None.

Available features depend on your Edition.

select * from v$version;

Regards
Michel
Re: grouping function [message #342469 is a reply to message #342362] Fri, 22 August 2008 07:43 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
One additional item you may notice is that GROUP BY in 9i "looks" like it also sorted by the GROUP BY column. It was just a side effect of the optimizer.
In 10g thankfully it does not, forcing you to properly use ORDER BY clauses.
Previous Topic: Email PL/SQL exception
Next Topic: Records count
Goto Forum:
  


Current Time: Sat Dec 10 11:10:15 CST 2016

Total time taken to generate the page: 0.26551 seconds