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',
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
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