Wednesday, March 24, 2010

A Short Guide To Open-Source And Similar Licenses - Smashing Magazine

It is very difficult to understand what you can do and what you cannot with the 3-4 page license screen. A simple write up on different licenses used in the open-source world. What they really mean and whether you can use – share the source: A Short Guide To Open-Source And Similar Licenses - Smashing Magazine

Saturday, March 20, 2010

Oracle NO_DATA_FOUND exception for SELECT INTO

When a SELECT INTO does not return anything the NO_DATA_FOUND exception is raised. The exception is not raised if a aggregate function like SUM or AVG is used, but we cannot use that for a varchar column. So, I am now catching the NO_DATA_FOUND exception in my procedure.
 
SELECT INTO VARIABLE_NAME <SQL statement that raises NO_DATA_FOUND exception>
   EXCEPTION
     WHEN NO_DATA_FOUND THEN
             VARIABLE_NAME :=0; --DEFAULT value of VARIABLE_NAME
             DBMS_OUTPUT.PUT_LINE('');
     WHEN OTHERS THEN
      ROLLBACK;
      MESSAGE :=
            MESSAGE
         || 'SQLCODE: '
         || SQLCODE
         || ' SQLERRM:'
         || SUBSTR (SQLERRM, 1, 100);

      DBMS_OUTPUT.put_line ('ERROR: ' || MESSAGE);

Tuesday, March 16, 2010

Language Learning on Livemocha

Want to learn a new language? Try LiveMocha at www.livemocha.com - over 50 languages!

Social Language Learning - Online!

  • Learn languages online at your own pace with fun language lessons

  • Connect with foreign language partners around the world

An online mind mapping tool https://bubbl.us/beta/

 

Bubbl.us is a simple and free web application that lets you brainstorm online.

With Bubbls.us you can

  • Create colorful mind maps online
  • Share and work with friends
  • Embed your mind map in your blog or website
  • Email and print your mind map
  • Save your mind map as an image

And it's FREE!

Features: http://bubbl.us/view.php?sid=7988&pw=ya71XC6HwyNHkMSRmVHlVLlVMcmR2TQ

Future: http://bubbl.us/view.php?sid=7991&pw=ya71XC6HwyNHkMSQ4WE01Lmwvd0Q0UQ

Sunday, March 14, 2010

Google Wave finally has email integration

Today when I logged into Google Wave I was greeted with a popup to enable Email integration.

1268572071768_2c788

I am wondering what took them so long to integrate Wave with Email. Email is still the single most frequently used app in the bundle. One of the biggest reason for its failure is the obscurity : till date I am trying to find a way to edit my settings. Why is everything in the form of waves!

Thursday, March 11, 2010

Go thataway: Google Maps India learns to navigate like a local

I need to remember to use it when I am visiting India! I wonder whether they kept surveying all locals for routes! This is incredible. I tested some long routes in Maharashtra and the directions I received were even better than what we use at present!!

in reference to: Official Google Blog: Go thataway: Google Maps India learns to navigate like a local (view on Google Sidewiki)

Monday, March 08, 2010

Set sequence to a predefined number

    alter sequence sequence_name increment by 800;

    select sequence_name.nextval from dual;

    alter sequence sequence_name  increment by 1;

Friday, March 05, 2010