oracle 创办视图报错

2012-12-22

oracle 创建视图报错CREATE OR REPLACE FORCE VIEW PCS.PCS_V_MARK_FACTORY(FACTORYCODE,FACTORYNAME)ASSE

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;