Search and compare

Hi, Oracle has a fuction that compares value and then returns another value. DECODE( expr, search, result [, search, result] ... [, default] ) E.g. DECODE (deptno, 10, 'ACCOUNTING', 20, 'RESEARCH', 30, 'SALES', 40, 'OPERATION',

Help about joins

Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer join column FROM em

Comress table

Hi, I want to compress my tables but I gets an error: C:\mysql-data\dtim9t>myisampack wi_abbreviation.MYI Compressing wi_abbreviation.MYD: (7221 records) - Calculating statistics - Compressing file myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13) Aborting: wi_abbreviation.MYD i