oracle 执行提示缺少表达式

[qq_39919170]

select to_char(blrq, 'yyyy-MM-dd HH24:mi:ss'),
*
from fjxx
where tablename = 'foster_service_info'
and fjlb = '4'
and fjid = '8081C764039F183C'
order by fjmc
执行提示缺少表达式

[qq_39919170]

引用 2 楼 liuzhijian2008x 的回复:

表加上别名就可以了。

好的 谢谢啊

[liu志坚]

select to_char(blrq, 'yyyy-MM-dd HH24:mi:ss'), t.* from fjxx t where tablename = 'foster_service_info' and fjlb = '4' and fjid = '8081C764039F183C' order by fjmc

[liu志坚]

表加上别名就可以了。

[碧水幽幽泉]

select to_char(blrq, 'yyyy-MM-dd HH24:mi:ss'),a.*
  from fjxx a
 where tablename = 'foster_service_info'
   and fjlb = '4'
   and fjid = '8081C764039F183C'
 order by fjmc