我使用如下语句建了一个视图:drop view "View_Manager_Log";/*==============================================================*/
/* View: "View_Manager_Log" */
/*==============================================================*/
create or replace view "View_Manager_Log" as
select a.logid,b.username,a.userip,a.userlogintime from j_log a ,j_manager b where b.managerid(+)=a.managerid order by a.logid desc;
然后使用SELECT * FORM View_Manager_Log;
进行查询,为什么报如下错误: *
ORA-00923: 未找到预期 FROM 关键字
我使用的Oracle8
/* View: "View_Manager_Log" */
/*==============================================================*/
create or replace view "View_Manager_Log" as
select a.logid,b.username,a.userip,a.userlogintime from j_log a ,j_manager b where b.managerid(+)=a.managerid order by a.logid desc;
然后使用SELECT * FORM View_Manager_Log;
进行查询,为什么报如下错误: *
ORA-00923: 未找到预期 FROM 关键字
我使用的Oracle8
要用select * from "View_Manager_Log";建议都不用双引号
我使用powerdesigner生成的代码,问题已经解决!