About "ORA-03113: End of file for communication channels"

Iamlaosong

A SQL query statement error, independent of the statement, regardless of the value in the condition, the error is ORA-03113, the statement is as follows:

SELECT * from TB_EVT_DLV A, TB_JG b,tb_evt_mail_clct C where a.mail_num=c.mail_num and   a.dlv_date between To_date (' 201 4-11-1 ', ' yyyy-mm-dd ') and to_date (' 2014-11-1 ', ' yyyy-mm-dd ') and   a.dlv_sts_code= ' I ' and   a.dlv_bureau_org_ Code =b.zj_code and   a.dlv_bureau_org_code like ' 23009201% ' ORDER by b.city,b.ssxs,b.zj_code,a.dlv_date

a mistake, close diagram One, appears in Figure II:

This error is definitely not related to communication, this error has been encountered before, when the condition is "23007300", the organization still error, but only in the Association SNCN_ZD_JG This table times wrong, and now found that "23009201" also error, more serious than that, replace the organization table TB _JG and SNCN_ZD_JG both error (see: a strange query statement (unknown reason)), it is very strange.

Change ' 23,009,201% ' to ' 230,092% ', or simply replace like '23009201%' with = '23009201' to execute successfully. As follows:

SELECT * from TB_EVT_DLV A, TB_JG b,tb_evt_mail_clct C where a.mail_num=c.mail_num and   a.dlv_date between To_date (' 201 4-12-10 ', ' yyyy-mm-dd ') and to_date (' 2014-12-10 ', ' yyyy-mm-dd ') and   a.dlv_sts_code= ' I ' and   a.dlv_bureau_org_ Code =b.zj_code and   a.dlv_bureau_org_code = ' 23009201 ' ORDER by b.city,b.ssxs,b.zj_code,a.dlv_date

remove the last table and change it to the following statement to execute successfully. as follows:

SELECT * from TB_EVT_DLV A, TB_JG b where a.dlv_date between to_date (' 2014-12-10 ', ' yyyy-mm-dd ') and to_date (' 2014-12-10 ', ' Yyyy-mm-dd ') and   a.dlv_sts_code= ' I ' and   a.dlv_bureau_org_code =b.zj_code and   a.dlv_bureau_org_code like ' 23009201% ' ORDER by b.city,b.ssxs,b.zj_code,a.dlv_date

I don't know why.

About "ORA-03113: End of file for communication channels"