ORA- 009004 b.remainTimeStart标识符无效

Question

CREATE VIEW v_t_invest_borrow_list AS
SELECT
b.id AS id,
c.username AS borrower,
b.borrowAmount AS borrowAmount,
b.borrowTitle AS borrowTitle,
b.borrowWay AS borrowWay,
b.borrowStatus AS borrowStatus,
b.paymentMode AS paymentMode,
b.annualRate AS annualRate,
b.deadline AS deadline,
b.isDayThe AS isDayThe,
b.borrowShow AS borrowShow,
to_date(b.publishTime,'YYYY/MM/DD，HH24:mi:ss') AS publishTime,-- 原先得:DATE_FORMAT(b.publishTime,'%Y-%m-%d %T')
c.creditrating AS credit,
(b.hasInvestAmount / b.borrowAmount) * 100 AS schedules,
to_date(b.remainTimeEnd - b.remainTimeStar,'HH24:mi:ss') AS times --原先得： TIME_FORMAT(TIMEDIFF(b.remainTimeEnd,b.remainTimeStart),_utf8'%H小时%i分%s秒') AS times
FROM (t_borrow b
LEFT JOIN t_user c
ON ((b.publisher = c.id)))
ORDER BY b.remainTimeEnd

Answer 1

数据表没有remainTimeStart这个列吧，自己检查下。追问

这是别人写好得mysql view语句，让我改成oracle得 原先语句应该不会有问题

追答

仔细检查下，你的表是不是有这个列，有时可能拼错也是正常的。