Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Query with COUNT DISTINCT

odabovalFeb 13 2008 — edited Mar 6 2008
Hello,

We are in 10g ...
I have to compute COUNT DISTINCT of customers, per month, and YearToDate.

Per month, I think I found it out ...
On the year to date ... I have no clue at all ... and I hope that you could provide me with a solution or advice...

Here is my example :
month cust
200711 A
200711 B
200712 A
200712 C
200801 A
200801 B
200802 A
200802 C
200803 A
200803 C
200803 A
200804 D

I would like to get this :
month cust_count cust_count_YTD
200711......2................2 (because cust A and B)
200712......2................3 (because cust A and C)
200801......2................2 (Back to 0 at the beginning of each year)
200802......2................3 (because cust A and C)
200803......2................3 (because cust A and C, and A but count distinct)
200804......1................4 (because D)

Thank you in advance,
Olivier

Comments

Pierre Forstmann
Very little has been published about Oracle 12 (except on some MOS notes) but it is very unlikely that PL/SQL would be no more supported: many applications would stopped working.
If Oracle Corp. decides to remove a database feature it is in general announced one or two releases before and this has not been made for PL/SQL.

Edited by: P. Forstmann on 5 juil. 2011 18:06
873404
Great ! Ok that sounds like an argument that PL/SQL will be supported in the future.

Do you know the release date of Oracle 12g ? Or more general what have been the release dates of Oracle 9 , 10, 11 ?

I just want to get an impresseion about the lifecycle of such a release....


Appreciate your help !

Greetings,
Dan
Pierre Forstmann
Oracle Corp has never announced a released date for a new Oracle database release up to now.


10g and 11g release dates are:

10.1 2003
10.2 2005
11.1 2007
11.2 2009


12.1 ????
Centinul
You might want to check the web. For example - Oracle Version Numbering/Release History

Also, you probably won't get any hard information from the forums members about a major release date unless it's already been made publicly available.
BPeaslandDBA
>
does anybody know if there will be PL/SQL Support with the release 12g of Oracle ?
That seems like an odd question. May I inquire as to why you asked it? The only thing I can think of more intrinsic to the workings of the database is SQL itself. Without PL/SQL, many applications that use PL/SQL would stop working. No more procedures, functions, etc. And a lot Oracle's own routines would no longer work.

Cheers,
Brian
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2008
Added on Feb 13 2008
5 comments
190,095 views