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,

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;

ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop]

Hey i got this error code when execute query on java form

ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x290EB6C18], [], [], [], [], [], []
The solution is just simply re-compile source of the view that used.

Check duplicate index

Rule for good index :

If 2 indexes ( I1 and I2 ) exist for a table and
   the number of columns in Index I1 is less or equal to the number of column
in index I2 and
   index I1 has the same columns in the same order as leading columns of index
I2
Then
   If index I1 is UNIQUE then
      If index I2 is used to support Foregh Key or for Index Overload then
         Do Nothing
      Else
         Index I2 can be DROPPED
      End If
   Else
      Index I1 can be DROPPED
   End If
End If

To check duplicate index, use this query :

1. from orafaq

SELECT   /*+ RULE */
TAB_OWNER.NAME OWNER, T.NAME TABLE_NAME,
O1.NAME
|| '('
|| DECODE (BITAND (I1.PROPERTY, 1), 0, 'N', 1, 'U', '*')
|| ')' INCLUDED_INDEX_NAME,
O2.NAME
|| '('
|| DECODE (BITAND (I2.PROPERTY, 1), 0, 'N', 1, 'U', '*')
|| ')' INCLUDING_INDEX_NAME
FROM SYS.USER$ TAB_OWNER,
SYS.OBJ$ T,
SYS.IND$ I1,
SYS.OBJ$ O1,
SYS.IND$ I2,
SYS.OBJ$ O2
WHERE I1.BO# = I2.BO#
AND I1.OBJ#  I2.OBJ#
AND I2.COLS >= I1.COLS
AND I1.COLS > 0
AND I1.COLS =
(SELECT /*+ ORDERED */
COUNT (1)
FROM SYS.ICOL$ CC1, SYS.ICOL$ CC2
WHERE CC2.OBJ# = I2.OBJ#
AND CC1.OBJ# = I1.OBJ#
AND CC2.POS# = CC1.POS#
AND CC2.COL# = CC1.COL#)
AND I1.OBJ# = O1.OBJ#
AND I2.OBJ# = O2.OBJ#
AND T.OBJ# = I1.BO#
AND T.OWNER# = TAB_OWNER.USER#
AND TAB_OWNER.NAME LIKE '%'
ORDER BY 1, 2

2. from dba-oracle

SELECT   /*+ RULE */
A.TABLE_OWNER, A.TABLE_NAME, A.INDEX_OWNER, A.INDEX_NAME,
COLUMN_NAME_LIST, COLUMN_NAME_LIST_DUP, DUP DUPLICATE_INDEXES,
I.UNIQUENESS, I.PARTITIONED, I.LEAF_BLOCKS, I.DISTINCT_KEYS,
I.NUM_ROWS, I.CLUSTERING_FACTOR
FROM (SELECT TABLE_OWNER, TABLE_NAME, INDEX_OWNER, INDEX_NAME,
COLUMN_NAME_LIST_DUP, DUP,
MAX (DUP) OVER (PARTITION BY TABLE_OWNER, TABLE_NAME, INDEX_NAME)
DUP_MX
FROM (SELECT     TABLE_OWNER, TABLE_NAME, INDEX_OWNER, INDEX_NAME,
SUBSTR
(SYS_CONNECT_BY_PATH (COLUMN_NAME, ','),
2
) COLUMN_NAME_LIST_DUP,
DUP
FROM (SELECT INDEX_OWNER, INDEX_NAME, TABLE_OWNER,
TABLE_NAME, COLUMN_NAME,
COUNT (1) OVER (PARTITION BY INDEX_OWNER, INDEX_NAME)
CNT,
ROW_NUMBER () OVER (PARTITION BY INDEX_OWNER, INDEX_NAME ORDER BY COLUMN_POSITION)
AS SEQ,
COUNT (1) OVER (PARTITION BY TABLE_OWNER, TABLE_NAME, COLUMN_NAME, COLUMN_POSITION)
AS DUP
FROM SYS.DBA_IND_COLUMNS
WHERE INDEX_OWNER NOT IN
('SYS', 'SYSTEM', 'DLOBAUGH'))
WHERE DUP != 1
START WITH SEQ = 1
CONNECT BY PRIOR SEQ + 1 = SEQ
AND PRIOR INDEX_OWNER = INDEX_OWNER
AND PRIOR INDEX_NAME = INDEX_NAME)) A,
(SELECT     TABLE_OWNER, TABLE_NAME, INDEX_OWNER, INDEX_NAME,
SUBSTR
(SYS_CONNECT_BY_PATH (COLUMN_NAME, ','),
2
) COLUMN_NAME_LIST
FROM (SELECT INDEX_OWNER, INDEX_NAME, TABLE_OWNER, TABLE_NAME,
COLUMN_NAME,
COUNT (1) OVER (PARTITION BY INDEX_OWNER, INDEX_NAME)
CNT,
ROW_NUMBER () OVER (PARTITION BY INDEX_OWNER, INDEX_NAME ORDER BY COLUMN_POSITION)
AS SEQ
FROM SYS.DBA_IND_COLUMNS
WHERE INDEX_OWNER NOT IN ('SYS', 'SYSTEM'))
WHERE SEQ = CNT
START WITH SEQ = 1
CONNECT BY PRIOR SEQ + 1 = SEQ
AND PRIOR INDEX_OWNER = INDEX_OWNER
AND PRIOR INDEX_NAME = INDEX_NAME) B,
DBA_INDEXES I
WHERE A.DUP = A.DUP_MX
AND A.INDEX_OWNER = B.INDEX_OWNER
AND A.INDEX_NAME = B.INDEX_NAME
AND A.INDEX_OWNER = I.OWNER
AND A.INDEX_NAME = I.INDEX_NAME
ORDER BY A.TABLE_OWNER, A.TABLE_NAME, COLUMN_NAME_LIST_DUP;