导入视图时,报错, ORA-00933:SQL命令未正确结束解决方法
发布时间:2010-05-20 14:01:29 文章来源:www.iduyao.cn 采编人员:星星草
导入视图时,报错, ORA-00933:SQL命令未正确结束
代码如下
create or replace view final_chief_diagnosis as
select
patient_id,
visit_id,
diagnosis_no,
diagnosis_desc,
diagnosis_date,
treat_days,
treat_result,
oper_treat_indicator
from diagnosis
where diagnosis_type='3' and diagnosis_no='1'
create or replace view v_emr_qc_patient_operation as
select PATIENT_ID,VISIT_ID,COUNT(OPERATION_NO) AS OPERATION_COUNTS
from OPERATION
GROUP BY PATIENT_ID,VISIT_ID
CREATE OR REPLACE VIEW V_EMR_QC_MTD_PATIENT AS
SELECT a.PATIENT_ID,
a.INP_NO,
a.NAME,
a.SEX,
a.DATE_OF_BIRTH,
b.VISIT_ID,
b.CHARGE_TYPE,
b.ADMISSION_DATE_TIME,
b.DISCHARGE_DATE_TIME,
c.STATUS,
c.REQUEST_DOCTOR_ID,
c.REQUEST_DATE_TIME,
c.PARENT_DOCTOR_ID,
c.SUPER_DOCTOR_ID,
d.WARD_CODE,
d.DEPT_CODE,
d.BED_NO,
d.ADM_WARD_DATE_TIME,
d.NURSING_CLASS,
d.PATIENT_CONDITION,
d.DIAGNOSIS,
'' as AGE,
'' as BED_LABEL,
0 as InHospitalDays,
0 as CommitMrDays,
0 as DischargeDays,
b.DEPT_DISCHARGE_FROM,
e.OPERATION_COUNTS,
b.MTD_VALUE
FROM PAT_MASTER_INDEX a, PAT_VISIT b, MR_ON_LINE c, PATS_IN_HOSPITAL d,V_EMR_QC_PATIENT_OPERATION e
WHERE (a.PATIENT_ID = b.PATIENT_ID)
AND (b.PATIENT_ID = c.PATIENT_ID)
AND (b.VISIT_ID = c.VISIT_ID)
AND (b.PATIENT_ID = d.PATIENT_ID)
AND (b.VISIT_ID = d.VISIT_ID)
AND (b.PATIENT_ID = e.PATIENT_ID(+))
AND (b.VISIT_ID = e.VISIT_ID(+))
AND (c.STATUS = '0');
CREATE OR REPLACE VIEW V_EMR_QC_PATIENT AS
SELECT a.PATIENT_ID,
a.INP_NO,
a.NAME,
a.SEX,
a.DATE_OF_BIRTH,
b.VISIT_ID,
b.CHARGE_TYPE,
b.ADMISSION_DATE_TIME,
b.DISCHARGE_DATE_TIME,
c.STATUS,
c.REQUEST_DOCTOR_ID,
c.REQUEST_DATE_TIME,
c.PARENT_DOCTOR_ID,
c.SUPER_DOCTOR_ID,
d.WARD_CODE,
d.DEPT_CODE,
d.BED_NO,
d.ADM_WARD_DATE_TIME,
d.NURSING_CLASS,
d.PATIENT_CONDITION,
d.DIAGNOSIS,
'' as AGE,
'' as BED_LABEL,
0 as InHospitalDays,
0 as CommitMrDays,
0 as DischargeDays,
b.DEPT_DISCHARGE_FROM,
e.OPERATION_COUNTS
FROM PAT_MASTER_INDEX a, PAT_VISIT b, MR_ON_LINE c, PATS_IN_HOSPITAL d,V_EMR_QC_PATIENT_OPERATION e
WHERE (a.PATIENT_ID = b.PATIENT_ID)
AND (b.PATIENT_ID = c.PATIENT_ID)
AND (b.VISIT_ID = c.VISIT_ID)
AND (b.PATIENT_ID = d.PATIENT_ID(+))
AND (b.VISIT_ID = d.VISIT_ID(+))
AND (b.PATIENT_ID = e.PATIENT_ID(+))
AND (b.VISIT_ID = e.VISIT_ID(+))
AND (c.STATUS = '0')
------解决方案--------------------
ORA-00933 SQL command not properly ended
Cause: The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or INSERT statement. ORDER BY cannot be used to create an ordered view or to insert in a certain order.
Action: Correct the syntax by removing the inappropriate clauses. It may be possible to duplicate the removed clause with another SQL statement. For example, to order the rows of a view, do so when querying the view and not when creating it. This error can also occur in SQL*Forms applications if a continuation line is indented. Check for indented lines and delete these spaces.
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。
其他相似内容:
-
创建同义词报ORA-00955
各位大神,我创建公有同义词,怎么会报ORA-00955错?很多人遇到建立私有同义词有这个错,我怎么建立公有同义词也...
-
impdp导入为什么索引会占的非常大。
本帖最后由 xixi_168 于 2014-07-19 23:10:47 编辑
在做数据...
-
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
测试没有成功。
ORA-12514: TNS: 监听程序当前无法识别连接描述...
-
oracle神牛进!!!
1、如何用sql查出oracle自带的所有函数?
2、给定ascii码,如何用sql查出对应的字符?
3、为什么在java中和在oracl...
-
oracle的cmd执行一个.sql文件,遇到异常时退出而不是继续执行
假设有一个1.sql文件,内容是
Declare
X varchar2(20);
Begin
Sc...
-
oracle查看某一条记录中为空的字段总数
oralce中,某一条记录中怎么得到这条记录中字段值为空的总数呢?(不为空的总数也可)
比如:id a1...
-
三台ORACLE通信,DBLINK
三台ORACLE服务器,A、B、C,其中A和B在同一个内网,B为双网卡可以连接外网,C为外网ORACLE。现在在B上已经建立DBL...
-
OracleOraDb10g_home1TNSListener无法启动
OracleOraDb10g_home1TNSListener无法启动,每次启动都提示:“在本地计算机无法启动Ora...
-
虚拟机安装RAC,网卡可以用NAT方式连接吗?
大家好:
我看教程上设的,安装配置RAC,配置虚拟机的两块网卡,第一块网卡(eth0,配置公用I...
-
求解oracle监听服务名问题
最近在做服务器的双机热备时,发现两边的监听服务名不一致,一个是OracleOraDb11g_home1TNSListen...