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!

changing the order sequence

user520824Oct 4 2007 — edited Oct 5 2007
Hello,

i have a table test contains these data.

group sequence value
1 1 100
1 2 200
1 3 300
1 4 400
1 5 500
1 6 600


Now i want to change the sequence. ie, eg change the sequence of 2nd record to 5th.
ie moving the 2nd record to 5th and re arrange the sequence. so the records get rearranged
with new sequence.


3 becomes ==> 2
4 becomes ==> 3
5 becomes ==> 4


so the records should looks like

1 1 100
1 2 300
1 3 400
1 4 500
1 5 200 --> 2nd record moved to 5th
1 6 600


how can i achieve this?

Comments

Dude!
Your link does not work, perhaps I need to create an account?

Are you referring to the same information available at http://www.oracle.com/us/technologies/027617.pdf

It shows different prices though, but might answer some of your questions. Some of the prices are based on system with 2 CPU's or unlimited CPU's. The document is from Sept 2010, pretty recent.
1 person found this helpful
EdStevens
waldorfm wrote:
Your link does not work, perhaps I need to create an account?

Are you referring to the same information available at http://www.oracle.com/us/technologies/027617.pdf

It shows different prices though, but might answer some of your questions. Some of the prices are based on system with 2 CPU's or unlimited CPU's. The document is from Sept 2010, pretty recent.
Interesting. That doc doesn't distinguish between "Basic Limited" vs. "Basic" and "Primier Limited" vs. "Premier".

The link I gave was simply the result of going to www.oracle.com, selecting "Linux" under the "server and storage systems" column, then clicking the "Buy and Save" button. Scroll down and you'll see 5 levels of Linux support, with links to details on each.
2919781
...and that document could be improved by making the service level descriptions extend each other, to fully emphasize the differences:

Today:

Oracle Linux Network Support:Access to software and updates through the Unbreakable Linux Network.
Oracle Linux Basic Support: Network access plus 24x7 support with global coverage and complete Linux server lifecycle management.
Oracle Linux Premier Support: Network access, 24x7 support with global coverage, complete Linux server lifecycle management, plus
back port of fixes to earlier releases as well as Oracle Lifetime Support.

Instead:

Oracle Linux Network Support: Access to software and updates through the Unbreakable Linux Network.
Oracle Linux Basic Support: Network Support plus 24x7 support with global coverage and complete Linux server lifecycle management.
Oracle Linux Premier Support: Basic Support plus back port of fixes to earlier releases as well as Oracle Lifetime Support.

Yeah, I know. Saturday evening and all, get a life. But hey, she's in the shower, and I'm ready to go!
Sergio-Oracle
Answer
In the store, when you drill down to Oracle Linux Basic Limited Support, you'll see:
Pricing metric is per system. The system can have a maximum of two physical processors (sockets), unlimited number of cores and/or virtual guests.
Whereas Oracle Linux Basic says in the overview:
Pricing metric is per system. The system can have unlimited number of physical processors (sockets), unlimited number of cores and/or virtual guests.
Sergio
Marked as Answer by EdStevens · Sep 27 2020
EdStevens
Sergio wrote:
In the store, when you drill down to Oracle Linux Basic Limited Support, you'll see:
Pricing metric is per system. The system can have a maximum of two physical processors (sockets), unlimited number of cores and/or virtual guests.
Whereas Oracle Linux Basic says in the overview:
Pricing metric is per system. The system can have unlimited number of physical processors (sockets), unlimited number of cores and/or virtual guests.
Sergio
Ah .. I see!

Thanks.
Dude!
I found another link:

http://www.oracle.com/us/corporate/pricing/els-pricelist-070592.pdf

Oracle Linux Premier Limited and Oracle Linux Basic Limited support services are available only for systems with no more than 2 physical CPUs per system. Where computers are clustered, each system within the cluster must have no more than 2 physical CPUs.

Oracle Linux Premier, Oracle Linux Basic and Oracle Linux Network support services are available for systems with any number of physical CPUs per system.

Oracle Linux Network Support - Access to software and updates through the Unbreakable Linux Network. This is the cheapest, with currently $119, and I guess that's all that is required to have access to ULN and all Oracle kernel patches. That's only $10/month.

To compare the price with Red Hat: https://www.redhat.com/apps/store/server/
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2007
Added on Oct 4 2007
14 comments
2,303 views