Sun Microsystems has announced that a special meeting of it's Board of Directors has approved a July 16, 2009 date for a special stockholder meeting to vote on the adoption of the proposed merger agreement with Oracle Corporation.On April 20, 2009, the companies jointly announced the merger. The transaction is valued at approximately $7.4 billion USD, with Oracle purchasing Sun stock with cash for $9.50 per share, a premium of nearly $3 per share over previous market value. Sun's Board of Directors had already unanimously approved the transaction and it is anticipated to close this summer, subject to this stockholder vote and regulatory approval.
In March 2009, IBM had previously expressed interest in purchasing Sun, for $7 billion USD, but withdrew the offer, citing concerns about executive compensation, a few weeks before Oracle made their bid.
Larry Ellison, Oracle's chief executive, has described Sun's Java platform as "the single most important software asset we have ever acquired."
In November 2008, Sun announced they would lay off 6,000 workers (about 18% of their global workforce) in order to cut operational costs. This is in addition to the 2,500 jobs that were cut in May of that year. At that time, Sun said they had posted a net loss of $1.7 billion USD, that year.
















For example :
SQL SERVER : Select top 10 * form table.
MYSQL
Oracle
For example :
SQL SERVER : Select top 10 * form table.
MYSQL
Oracle
It's possible with rownum to upper limit a query but when you want to use a lower limit or sort the query it's not really a "beautiful" to do it. It's even a really ugly way to do it. We have Oracle 10g here and since rownum is done before the order statement if you do rownum < 10 you will get the first 10 rows the BD will return before any order statement. If you want to select the first 10 lines sorted you need to do a select included in another select and add rownum as a column returned by the first ordered select statement. You need to do the same trick if you want to get a lower limit since rownum > 10 doesn't work in the first select statement.
SELECT junk FROM (SELECT rownum as RN, junk FROM SOME_JUNK ORDER BY junk_unindexed) WHERE RN < 10
SELECT junk FROM (SELECT rownum as RN_INCREMENTED, junk FROM SOME_JUNK WHERE ROWNUM < 10) WHERE RN_INCREMENTED > 2
Last edited by LaP on 12 Jun 2009 - 13:51
PS I agree with n_K that there are serious issues here for the open source community, especially mysql.
Commenting has either been disabled on this article or you are not logged in. Click here to login or register, its free!
Note: Anonymous commenting is disabled in order to keep the quality of responses to a high standard.