Wired News

Definition / Concept If we need to retrieve data from more than one table we use JOINs. A join is a query, used to retrieve data from more than one table based on JOIN condition (Note: Same table can referenced more than once). Conditions In SQL terms, Join occurs when we specify more than one table in the FROM clause of the SELECT statement. Additionally, we also specify a condition in the WHERE clause to specify JOIN condition in the SELECT statement. Now, JOINs are conditions to join/compare two tables’ data retrieved from the selected tables’ columns based on JOIN Condition. Oracle combines the rows’ data to compare with other tables’ rows and evaulate the JOIN condition for TRUE/FALSE. We need to qualify columns having same name with table names/aliases to avoid ambiguity errors, for joins can be extended to multiple tables. In case of multiple joins extending to more than 2 tables, let’s say 3 for example, we create a recordset based on 1st join between 1st two tables & j...

Google is launching web-based spreadsheet application called Google Spreadsheets . Still under beta test, requiring invites to try out this new application; nothing much can be said about the application & its future as of now. But, as I was going through various news articles, people are already claiming that Google is seriously competing with Microsoft by launching this spreadsheet program. In my opinion, it’s just small view of a bigger vision. For, I believe it’s not just about Google taking on Microsoft or any other XYZ Co., but what Google is trying to achieve is reducing the dependance of the users on an operating system largely. When we observe the recent moves made by Google, we observe that Google launched Email , Instant Messaging , Calendar etc and now Google Spreadsheets, a spreadsheet application. The straight & obvious advantage of all such applications is availability on the web, so no matter where you are, you’ve access to your information everytime; no more d...

A group of four full-time political activists have developed a portal to encourage Internet Explorer users to adopt Firefox Web Browser. They’ve launched their website: ExplorerDestroyer.com as an aggressive strategy to promote Firefox amongst Internet Explorer Users, as Internet Explorer is still the most popular Web Browser. The group states : “Firefox is one of the most important software applications in the world because it can play a big part in determining the future of the web. It is crucial that an open-source, standards-based web browser becomes the most popular browser, and Firefox has a shot at being that. It’s the best product, and its popularity is climbing, thanks to amazing efforts by the Mozilla Foundation , the SpreadFirefox.org juggernaut, and many others.” Apart from talking about the advantages of Firefox, they are promoting the use of Firefox, by advertising the Google Adsense program that pays $1 for each new Firefox user you refer. Also, they are offering ready...