For quite a few days I was searching for something that gives me the ability to
- open a link (outside webpage) in a popup window
- Open HTML controls in popup
- Can show images in the popup
- Can show images as a slideshow in a popup
- Can show inline HTML in a popup
- Should be sexy, not like the old school HTML popup window
- Download executable jar from here.
- Put the downloaded file in C drive or anywhere you like
- Open command prompt ( Start > Run > write cmd and press OK)
Filed under: Glassfish, Programming, Tutorials, Web/Application Server, Windows | 1 Comment
Tags: application server, glassfish, Installations, java, web server
I had a situation today, I accidentally executed SQL insert script twice. The bad thing was that the table had no primary key or unique key defined which may have stopped it from execution.
Lesson: Not having Primary keys is a bad idea
So, now I can not delete each row manually so I had to write a query which could do that for me. Thanks god it saved me a lot of time.
So here goes the query, rather queries for performing the same functionality.
Filed under: Oracle, SQL, TOAD | Leave a Comment
Tags: database, delete duplicate, Oracle, SQL, sql delete, sql delete duplicate, TOAD
Finding highest or lowest number in a column is easy, you can do that with max() and min() SQL function. But I had recently been asked in an interview to write a query that could find the second highest value in a table column.
Ooops, and I didn’t do well in that interview either.LOL
Before showing you the query, first, let me make things more easy for you. Here is the table script for our very simple JOB table.
CREATE TABLE AAMT.JOB
DESCRIPTION VARCHAR2(50 BYTE)
Done? Lets move on and insert a few records in JOB table.
Insert into JOB (JOB_ID, DESCRIPTION) Values (1, ‘Teaching’);
Insert into JOB (JOB_ID, DESCRIPTION) Values (2, ‘Programming’);
Insert into JOB (JOB_ID, DESCRIPTION) Values (3, ‘Administration’);
Insert into JOB (JOB_ID, DESCRIPTION) Values (10, ‘DBA’);
Insert into JOB (JOB_ID, DESCRIPTION) Values (5, ‘Pilot’);
Insert into JOB (JOB_ID, DESCRIPTION) Values (8, ‘Security’);
OK, ladies and gentlemen here goes an Oracle query that does the same. Rownum is our thing here, rownum will serve our purpose .I hope it would be helpful for you.
select job_id from
(select rownum r,job_id from job order by job_id desc)
This is another version I found on web
SELECT job_id FROM
(SELECT job_id,row_number() OVER (ORDER BY JOB_ID DESC )r FROM job)
Both queries return
I hope this would help.
Please leave feedback or if you have better solution, please share.
Filed under: Oracle, SQL, TOAD, Tutorials, Uncategorized | 3 Comments
Tags: database, highest number, Oracle, queries, second highest, SQL
The GNOME project is proud to release this new version of the GNOME desktop environment and developer platform. Among the hundreds of bug fixes and user-requested improvements, GNOME 2.26 has several highly visible changes: the inclusion of a new disc burning application, simpler file sharing and a generally smoother user experience. Learn more about GNOME 2.26 through the detailed release notes.
For more news, tech tutorials and tech information click here
Filed under: gnome, Linux, Open Source, Open Source News | Leave a Comment
Tags: gnome, gnome 2.26, gnome 2.26 release notes, gnome 2.26 released, latest gnome, linux gnome
The next ubuntu stable version is going to be released on 23rd April 2009.If you want to order your free CDS use the following linkhttps://shipit.ubuntu.com/
If you want to know new features in ubuntu 9.04 as follows
* Linux kernel version 2.6.28
* A new notification system
* Faster boot times
* GNOME 2.26 desktop environment
* Community desktop themes and brand new artwork
* Evolutionary EXT4 filesystem
* Support for many new devices (wireless, webcams, mobile phones, etc.)
Filed under: Uncategorized | Leave a Comment
Tags: free ubuntu cd, Ubuntu, ubuntu 9.04, ubuntu 9.04 new features
Its almost ready 🙂 Here is what Ubuntu team has to say
Upgrading from Ubuntu 8.10
To upgrade from Ubuntu 8.10 on a desktop system, press Alt+F2 and type in “update-manager -d” (without the quotes) into the command box. Update Manager should open up and tell you: New distribution release '9.04' is available. Click Upgrade and follow the on-screen instructions.
To upgrade from Ubuntu 8.10 on a server system: install the update-manager-core package if it is not already installed; edit /etc/update-manager/release-upgrades and set Prompt=normal; launch the upgrade tool with the command sudo do-release-upgrade; and follow the on-screen instructions.
Get it while it’s hot. ISOs and torrents are available at:
http://releases.ubuntu.com/releases/9.04/ (Ubuntu Desktop, Server, and Netbook Remix)
http://cdimage.ubuntu.com/releases/9.04/rc/ (Ubuntu MID)
http://cdimage.ubuntu.com/edubuntu/9.04/rc/ (Ubuntu Education Edition)
http://cdimage.ubuntu.com/netboot/9.04/rc/ (Ubuntu ARM)
Filed under: Uncategorized | Leave a Comment
Tags: Ubuntu, ubuntu 9.04, ubuntu latest version