Sunday, October 31, 2010

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 .

Friday, October 22, 2010

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 

Friday, October 8, 2010

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

Monday, October 4, 2010

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 )

    Friday, October 1, 2010

    Creativity And Negativity go side by side

    Creativity , as the name suggests is nothing but creating things that does not exists. Its something like giving a life to anything.Most animations are a product of creativity where an animal speaks to a bird or a snake takes to a  mongoose. This can sometime be related to dreaming .One powerful aspect of dreaming is to reach the extreme corners of the world or the places which you have not come across with the power of imagination.

    On the other hand Negativity is something like opposing , or thinking the reverse always.The one common thought that describes Negativity is to question oneself like What if ? What if i don't ? . Here more often one think that we cannot achieve anything because of the fear of failure that strikes most of the minds.

    There is a lot of possibility that both go hand in hand sometimes which always has a real time impact , take a real time consideration that strikes ones mind, say you got a creative thought of jumping from a flying plane which is too high and without even thinking negatively you take a fall from plane and end up crashing on land creatively.If you had got a negative thought at that time of falling ,then you would carry a parachute along and then you could land safely.

    From above thoughts sometimes think negatively along with creativity and see how success could follow you . This is applicable to real life experiences also ,may it be in field of business , artwork or anything for that matter.The only mantra to think here is "Be Negeto-creative" and change the way of thinking

    LinkWithin

    Related Posts with Thumbnails
    Make Money Blogging