iPhone Killer from Nokia

Nokia 5800 Xpress Music Tube

Next episode will be Nokia 5900 to be iPhone Killer “the next generation” (or just rumor). This rumor could prove to be false though since the source is from China, and we know just how many cloned handsets have made their way there to date. But i may hope there will be another successor to the Nokia 5800 XpressMusic.

Here some picture about it,


Advertisements

Change MySQL root password

1. use command line by going to the Start Menu > Run and typing cmd
2. change your directory to wherever you installed mysql to:
C:\> cd C:\mysql\bin
3. open mysql command line:
C:\mysql\bin> mysql -u root mysql
4. reset a new password:
mysql> SET PASSWORD FOR root@localhost=PASSWORD(‘pandazen’);
where “pandazen” is the new password you want to use

Nokia Hidden Code Tips

Here some useful Nokia secret code

*#0000#    – Check phone software version
*#06#          – Phone IMEI, more information on IMEI codes.
*3370#       – Activate Enhanced Full Rate Codec (EFR) – Your phone uses the best sound quality but talk time is reduced my approx. 5%
#3370#      – Deactivate Enhanced Full Rate Codec (EFR)
*#7370#* – To Reset phone

Nokia 5800 Software

I bought Nokia 5800 XM for Rp. 3.435.000,- (USD 338,4) on August 21, 2009.

I am a bit disappointed because i got some stuff not included on my nokia 5800 package. Is this the new package for new Nokia 5800 that do not included
– one backup stylus
– kickstand
– slip case
– TV-Out cable ? Hmm….. how unfortunate i am.

But it’s time for me to hunt software application to have fun with this tube.

Some useful Nokia Tips and Tricks

1. Opera Mini
2. Nimbuzz
3. Google Maps Go to this link directly from your mobile phone.
I had try it but there is a problem. For there further information, keep looking some fix from

Google Mobile Help

4. Mobile Paint
5. Handwriting Calculator
6. Y-Browser (File Manager)
7. ..

Here some list link to another stuff for Nokia 5800 XM (Tube 5800)

Applications from Nokia

SoftArchive.net

S60 5th Edition Freeware Downloads for Nokia 5800

http://www.bitsforfree.eu/5800_list.html

http://www.symbianthemes.us/nokia_5800_xpressmusic

http://sjc-nokia5800.blogspot.com/

http://www.getjar.com/software/Nokia/5800_XpressMusic

Show hidden folder in Windows

Yesterday, I called by friend complained that folder in the computer can not even show after edit option in the “folder option” | “show hidden files and folders”.

So here some solution i found after googling,

– open registry using regedit
– find key “HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced
change “Hidden” key value to 1
– test it, if folder can’t show yet
find key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\
Advanced\Folder\Hidden\SHOWALL

change “CheckedValue” key value to 1
– check again, if can’t show yet
try to unregister two .dll file from “Start” | “Run”
type regsvr32 /i browseui.dll, press OK
type regsvr32 /i shell32.dll, press OK
– after above step, the computer should show hidden folder
if it can’t show, maybe your computer had been infected by some virus.
Use antivirus to scan and fix your operating system to normal condition

(^_^)

Select Top-N in Oracle

Use DENSE_RANK to select top-n of a table in Oracle

SELECT *
FROM (SELECT EMPLOYEE_ID, FIRST_NAME, SALARY,
DENSE_RANK () OVER (ORDER BY SALARY DESC) TOPRANK
FROM HR.EMPLOYEES)
WHERE TOPRANK <= 3

How to exit from a procedure in Oracle

To exit from function is easy, just put “RETURN”

CREATE OR REPLACE FUNCTION MIS.FC_GET_ACCRUAL_COM(VAGR IN VARCHAR2) RETURN NUMBER IS
VNUM NUMBER;
BEGIN
SELECT AGR INTO VNUM FROM TAGR WHERE AGR = ‘AA’;

IF VNUM = 0 THEN
RETURN 1;
ELSE
RETURN 2;
END IF;
RETURN VNUM;
EXCEPTION WHEN OTHERS THEN
RETURN 0;
END;
/

To exit from procedure also easy, just use “RAISE”

CREATE OR REPLACE PROCEDURE TEST_EXIT
IS
HOI EXCEPTION;
BEGIN
RAISE HOI;
DBMS_OUTPUT.PUT_LINE (‘hoi’);
EXCEPTION
WHEN HOI
THEN
NULL;
END;