Google Music India - Music search made simpler

Google has launched its Indian music search which is the best music search i have come across the internet.All the other music search has either limited songs or songs that do not match the search criteria selected by users.Currently the Google music search is for hindi songs and the english version is yet to be released.

The tagline for this search is " Search for artists, albums or songs ".Currently the collections of hindi songs are their music partners in.com, saavn and saregama . The search displays a thumbnail of music poster with recent movie releases on the landing page.

The search powers bollywood songs , traditional songs , albums , song by various artists and the users can even search by the title of the song.Thumbs up to the Google music search where music search is made simpler.Lets hope the English version would be available soon

The link to the site is ( here )

Query to display timestamp along with date component

As most of us are aware what a Sysdate Function performs , it does return a DATE value when you query the current system date . The Sysdate is a powerful function used very often when you want to consider the system date in various coding practices.If one wants the function to return a immediate next days date then just add a 1 to the sysdate as ( sysdate + 1 ) .This will return the immediate next day's date.

Usage : Select sysdate from dual ;

Coming to the Sql query to see the time stamp component , you need to convert the sysdate format into character specifying what format of date and time you want to see.

Solution : Select  to_char ( sysdate , ' DD-MON-YYYY HH24:MI:SS ' )  from  dual ;

The result would be similar to this :

The Sysdate includes the timestamp component also but while displaying it only shows the date component and when to convert that using to_char function you could see the time component also.

To exclude the time component from sysdate function ,

use - Trunc ( sysdate )
The above function truncates the time component and returns only date component .

Download Missing Windows .dll files immediately - Dlldump

This is most common error you often see that a single or multiple (.dll) files are missing or corrupt when you have installed the application software or any other software that you use.The error could also be your system supporting dll files corrupt.

DLL - stands for dynamic link library which plays a major part in windows operating system.I had installed one software ,which showed .dll was missing . So i did a small research and found a cool site which holds large collection of dll files , and that s DllDump.com

DllDump.com - search for the dll file and download it  immediately , the reason why am using dlldump is that it allows immediate download option for user rather than misleading users with download here ,download there which the other sites normally do.Link to the site is ( here )

screen shot of dlldump website :

Dll Dump.com snapshot

Example Error : The program can’t start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this program
Solution : After download , whats next ? where do i place the downloaded dll files ?

- Look for folder named system32, its located at /WINDOWS/ folder or use a folder search option in windows .

- Place the file in system32 directory and then re-start your application , if not re-boot /re-start your computer.Hope this works.

Tip :

• For 32 bit Windows : use -  C://WINDOWS/system32
• For 64 bit Windows : use - C://WINDOWS/SysWOW64
  

If not , try registering the ( .dll ) file present in the system32 folder after the download ,

Registering Dll file :
Type the following on the Windows Command Prompt
<>   

regsvr32.exe   Your_Dll_file.dll

After that restart / reboot the application or system.

Just for your information on Unregistering the dll :
<> 

regsvr32.exe  /u  Your_Dll_file.dll

A small difference in usage of " if - else if - else " in pl/sql , vb , Unix

The underlying logic of all the programs are same , only there is slightly change in their syntax and usage.I had worked on VB 6  past so always in that mode whenever using the other languages like PL/SQL .As i was working on "if-then-else " for pl/sql and found that it was flashing the syntax error . There is a small difference of this usage in three languages .

The following are the differences of  IF-THEN-ELSE used in VB , PL/SQL and UNIX shell scripts :

1) VB :

if ( condition ) then
    some_statements
else if  ( condition )
    other_statements

else

    final_statements
end if


2) PL/SQL :

if ( condition ) then
    some_statements ;
elsif  ( condition )

    other_statements ;

else

    final_statements ;
end if ;

UNIX :

if ( condition ); then
    some_statements
eif  ( condition );
    other_statements

else

    final_statements

The feature I wish my smart phone had !

Nowadays everyone s crazy about smart phones , people tend to see others phone and think why didnt i have those features in my phone ? Android is fighting with Symbian and MeeGo is new baby to be born, watching those two fight lets wait for new features . Wat so ever the final downline for all these are Features , features and Features that your smart phone had !!!

The feature i wish my smart phone had :

• Automatic Voice Translator : Feels good to hear but that is  possible in near future , afterall its Technology Boss , A smart phone which can translate to any language on the go without having to worry much about the unknown languages of the world.Need to speak to a Japanese ,just speak English and the rest of conversion should be done by smart phone.
• Audio-Video : The basic feature with powerful touch , When a person call s , His/Hers recorded original voice cum video should be the ringing tone present in smart phone 
• Everything in One-Touch :  One-touch Mail , One-Touch internet , One-touch answering to call ,One-touch avoiding of calls , One-touch music , One-touch video , One-touch radio , One-touch games , One-touch chatting , One-touch shopping , One-touch payment , One-touch fund transfer , One-touch love and last One-touch smart phone
• Mood Changer : From Angry , Sad , Frustrated , Bad to Happy and smiling mood . The moment you look at your smart phone , all the negative behaviour turns positive there by increasing Life span ( ha ha )
• Solar cum Electric charger : Dual charging options either by solar energy or by electrical energy , alternative for " save Electrical Energy "
•  Friendship Express : Connect with anyone anywhere to any corner of the world with smart phone thereby " bringing the World Closer " .
• Simple Slim and Trendy : Light weight , simple and cool looking phone which should be a trend setter.

This creative entry was written for Tata Docomo " Share Life Contest " for Indiblogger . Tata DOCOMO OneTouch Net Phone is ( here )