2011年1月28日 星期五

BEA-000000: Rowkey does not have any primary key attributes

The Error: Rowkey does not have any primary key attributes.
Because the query for the displaying list doesn't have "Primary key".

2011年1月21日 星期五

Oracle: Check ISNUMBER

select decode(translate('A123456','1234567890','Y'),'Y','Y','N') from dual

select decode(translate('123456','1234567890','Y'),'Y','Y','N') from dual