Skip to Main Content

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.

Assign group value based on lag value change

325647Feb 20 2010 — edited Feb 20 2010

I have some old data that has a structure determined by order. The groups are in ascending order, based that the amount column, and delineated by when the previous value is less than the current value. I just need to assign a unique group ID to each group. This is what I have:

Order	Amount	Group
1	56
2	63
3	41
4	52
5	59
6	74
7	39
8	42
9	44
10	51
11	62
12	77

and this is what I would like:

Order	Amount	Group
1	56	1
2	63	1
3	41	2
4	52	2
5	59	2
6	74	2
7	39	3
8	42	3
9	44	3
10	51	3
11	62	3
12	77	3

I can get the previous value with the lag function but am struggling with assigning the number. I am a sql more than pl/sql person. TIA.

Comments

Dude!
I don't know if this answers your question about the fitness of support services, but Oracle Linux, including UEK kernel is listed in the Certification and Support HP ProLiant & BladeSystem Server web site at http://h18000.www1.hp.com/products/servers/linux/hplinuxcert-oracle.html and the highway to DELL seems http://content.dell.com/us/en/enterprise/oracle-solutions
Billy Verreynne
Thanks, but the specific models I'm looking at are not covered by that list. Also, seems like most of the models that are listed, are listed as "+certification pending+" and not as certification fully completed.
Dude!
There are more systems listed in the HP Archive section. But I guess I see what you mean now... Systems, in particular at the HP Archive link are all HP tested, but not HP supported and partner certified. A certified hardware configuration might be required for a business case, although from what I know, no vendor provides a guarantee or legal liability anyway. Regarding support, I'd say all OS issues should be addressed according to your support subscription. e. Oracle ULN.

Some more link I found "The Oracle Enterprise Linux Software and Hardware Ecosystem"
http://blogs.oracle.com/sergio/entry/the_oracle_enterprise_linux_so

Edited by: Dude on Nov 28, 2011 7:27 AM
LenzGrimmer
We maintain a list of certified systems at https://linux.oracle.com/hardware.html
This FAQ (http://linux.oracle.com/hcl_faq.html) and the support policies linked from https://linux.oracle.com/ should explain the support process.
In general, if there is a bug in the kernel, we'll try to fix it.
Sergio-Oracle
Billy,

Can you send an email with details of the server you are interested in seeing on the HCL to: hcl-info_ww [at] oracle [dot] com ?

Sergio
Billy Verreynne
Thanks for the responses guys.


Thanks Sergio, appreciate it. Will make use of it when management has selected a specific server model from the shortlist I provided them. We're looking at replacing the older V-class Sunfire servers (x86 AMD). End-of-maintenace of these servers are Q4/2012. I'm looking at the newer Sunfire, ProLiant or PowerEdge rack servers (1 rack unit ) specifically.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2010
Added on Feb 20 2010
6 comments
8,758 views