If you want to fetch the results between Xth row and Yth row in an Oracle resultset, here is the most optimal solution.
This works in Oracle 8.1 and above.
select *
from ( select a.*, rownum rnum
from
( YOUR_QUERY_GOES_HERE
-- including the order by ) a
where rownum < = MAX_ROWS )
where rnum >= MIN_ROWS
source : Ask Tom
You must have seen the Google suggest and the a9.com. But there are a huge number of Web 2.0 search engines. Here is the entire list
http://oedb.org/library/features/top-25-web20-search-engines
Just search for arunma in http://www.ajaxwhois.com/ and click the WhoIs link in the box. (never thought my details are so public)
Krugle, most famous open-source code search engine, now powers the Yahoo Developer Network search. Not a simple step for Yahoo though, because Yahoo just a few months back scrapped its Java code and developed its pages using PHP. If you ask what Java has to do with Krugle, then this is the answer.
Krugle is built on top of Apache Lucene, 100% Java based search engine API. Is Yahoo coming back to Java?
Developers talk: You can just try your hands on Lucene with just 4 or 5 lines of code. Please search for Lucene/Nutch for more details. Mind blowing.
A few days back i posted a few Google search hacks. But i recently got this two-page cheat sheet for Google. I am sure it will useful to everybody.
Vista, at the minimum needs a 1GB RAM on your machine. (Dont believe the Microsoft minimum requirements.) Thats old story.
Now, the hottest topic is the Digital Rights Management/Digital Restrictions Management. What does this mean? Nothing except that you wouldnt be able to run any DVD or CD that has no copyright information. You create a home video yourself and you can never run it on Vista. Microsoft has also worked so much for implementing the “copyright protection technology” on the upcoming media formats – HD DVD and Blue ray discs.
Guess what. There are lot many companies which are “anti-DRM” and sell CDs/DVDs on the internet. Meaning, you buy a legitimate disc and still will not be able to run on your system.
“Sometimes output is prevented entirely. Vista spends time monitoring itself and what you do, looking for things it thinks you shouldn’t be doing. If it finds something, it will limit functionality on you or, if you’re being really naughty, restart the video subsystem to prevent you from doing what you want.”
Hollywood had been distributing its movies in the uncrackable HD-DVD and Blue Ray discs. But just like DRM, the Vista code for the copyright protection doesnt work. It has been cracked the next day Vista was released. And Microsoft, as usual, raised a patch for it. Now, the DRM for the HD-DVD and the Blue Ray discs have been cracked by a Java utility. Illegal but.
How long are we going to live with something illegal? A 8$ licensed Iran Vista and an illegal workaround to access HD-DVDs, No card reader support. And above all this, your present hardware wouldnt simply run it. If you say that “Windows supports all hardware. So i stick to it”, try Vista. Linux, currently, supports more hardware than Vista. And if you own a 64 bit processor and trying to run a 64 bit version of Vista, you are in a very bad shape still.
Besides, all your third party drivers must now be certified by Microsoft. Otherwise, they simply wouldnt run. And how many drivers today do you think are really certified by Microsoft.
If you really want to stay with Windows, stay with whatever you have now. Vista is too dangerous a pet to play with.
Earlier last year, Kerala opened the doors of its schools to Linux. Now its the turn of its big neighbour, Tamil Nadu to choose Linux over Windows.
The Electronics Corporation of Tamil Nadu (ELCOT), which is the government owned entity that brings IT-enabling services to the state has chosen Open Source solutions over Windows-based solutions.
ELCOT decided in favor of open-source software because of its lower cost than proprietary software from Microsoft Corp. and other vendors, C.Umashankar, managing director of ELCOT, said Wednesday. Open-source software also provides better ease of operation and higher security, he added.
Further, this could be just what is required for the state government to choose Linux as well. ELCOT will migrate to Linux at the server and the desktop levels. Something tells me they might choose Ubuntu for their desktop. Last year, the Ubuntu India mailing list saw some activity and the name ELCOT turned up back then too.
unedited from http://ubuntu.wordpress.com/
You can either create a html file with the following markups inside or click the link at the bottom of the post.
<html>
<body>
<script type=”text/javascript”>
var x = navigator
document.write(“CodeName=” + x.appCodeName)
document.write(“<br />”)
document.write(“MinorVersion=” + x.appMinorVersion)
document.write(“<br />”)
document.write(“Name=” + x.appName)
document.write(“<br />”)
document.write(“Version=” + x.appVersion)
document.write(“<br />”)
document.write(“CookieEnabled=” + x.cookieEnabled)
document.write(“<br />”)
document.write(“Platform=” + x.platform)
document.write(“<br />”)
document.write(“UA=” + x.userAgent)
document.write(“<br />”)
document.write(“BrowserLanguage=” + x.browserLanguage)
document.write(“<br />”)
document.write(“SystemLanguage=” + x.systemLanguage)
document.write(“<br />”)
document.write(“UserLanguage=” + x.userLanguage)
</script>
</body>
</html>
ever imagined what you could do with a touchscreen monitor. Worse still, your machine runs on Linux?
Now watch this video and and tell whether Windows could ever come closer to this in the next 10 years comparing the sleekness and the memory consumption. Beryl comfortably runs on 512 MB memory and a decent processor. Here is a feedback by one of the bloggers.
“I’ve got Beryl running very nicely on a P3 800 with 512MB of RAM and a GeForce 6200 card. The only thing that’s slow is resize. Everything else is pretty snappy.”
Wanna try Ubuntu?
You can either order your Gnome version of ubuntu at https://shipit.ubuntu.com/
or the KDE version of Ubuntu (I just love this) at https://shipit.kubuntu.org/
What you can order is Kubuntu/Ubuntu Dapper Drake 6.06 which is 6 months old. My personal advise is to download the latest version Kubuntu Edgy Eft 6.10 at http://www.kubuntu.org/download.php. Stable, no spyware, no viruses, runs comfortably on machines suffering from “low memory” disease.
Ubuntu has its new version released every 6 months. Next comes in April is Fiesty Fawn. You can also download an Alpha release of it.
I am not a great fan of NetBeans now that i am completely addicted to Eclipse. But recently I heard that NetBeans does a lot of magic with UML design and reverse engineering. So, thought I could try it. As usual, the “21 day” still applies.
You too are interested? Just order your Netbeans free CD at http://www.netbeans.org/about/cd-form.html
