oracle 创建视图报错
CREATE OR REPLACE FORCE VIEW PCS.PCS_V_MARK_FACTORY
(
FACTORYCODE,
FACTORYNAME
)
AS
SELECT 'FACTORYCODE', 'FACTORYNAME FROM' pcs_itf.MARK_FACTORY;
报个语法错误 ?
求解实在没看出来 。
[解决办法]
SELECT 'FACTORYCODE', 'FACTORYNAME FROM' pcs_itf.MARK_FACTORY;
--没有from 语句
SELECT 'FACTORYCODE', 'FACTORYNAME' FROM pcs_itf.MARK_FACTORY;
CREATE OR REPLACE FORCE VIEW PCS.PCS_V_MARK_FACTORY
(
FACTORYCODE,
FACTORYNAME
)
AS
SELECT FACTORYCODE, FACTORYNAME FROM pcs_itf.MARK_FACTORY;