出错信息是: SQL> select *,'' as ToUserID,1 as IsRed from IMMessages order by IMMessages.CreatDate desc; select *,'' as ToUserID,1 as IsRed from IMMessages order by IMMessages.CreatDate desc * ERROR 位于第 1 行: ORA-00923: 未找到预期 FROM 关键字
该成这样试试: select IMMessages.*,'' as ToUserID,1 as IsRed from IMMessages order by IMMessages.CreatDate desc;
SQL> select *,'' as ToUserID,1 as IsRed from IMMessages order by IMMessages.CreatDate desc;
select *,'' as ToUserID,1 as IsRed from IMMessages order by IMMessages.CreatDate desc
*
ERROR 位于第 1 行:
ORA-00923: 未找到预期 FROM 关键字
select IMMessages.*,'' as ToUserID,1 as IsRed from IMMessages order by IMMessages.CreatDate desc;