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
執行提示缺少運算式
uj5u.com熱心網友回復：
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
uj5u.com熱心網友回復：
表加上別名就可以了。uj5u.com熱心網友回復：
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
uj5u.com熱心網友回復：
好的 謝謝啊轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/71810.html
標籤：基礎和管理
上一篇：ORACLE創建表空間