在oracle数据库内想将车位这一列设置位“A1”,以后不管加几个车牌号,车位都是A1
希望帮帮忙,很急
CREATE OR REPLACE VIEW CAR_IN(CARLICENCEview,CARTYPEview,TIMECARINview,CARFEEview)
AS
SELECT CARLICENCE,CARINFO.CARTYPE,TIMECARIN,FEE*trunc((sysdate-TIMECARIN)*24)
FROM CARINFO,FEESTAND
WHERE TIMECAROUT IS NULL AND CARINFO.CARTYPE = FEESTAND.CARTYPE AND carinfo.chewei=01
视图是这样建立的,不是特别会