qq 117791303

原创 XML CDATA

xml.append("<![CDATA["); xml.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); xml.append("<Service>"); xml.append("<Header>"); xml.append(" <ServiceCode>XXXX</ServiceCode>"); xml.append(" <Chan...

原创 CRM ----＞ Xxxx login UML

原创 log4j

日志没打开。

原创 requirement analysis report

原创 ORA-12541:tns:no listener

ORA-12541:tns:no listenerD:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

原创 API CODE --- BIZ CODE

原创 version control

原创 Oracle LISTAGG

SELECTLISTAGG(type_app, '#') WITHIN GROUP (ORDER BY cust_no) AS typeFROMTABLE;

原创 DateUtil.java 20200921

原创 oracle TO_CHAR TO_DATE

SELECT * FROM testWHERE 1 = 1 AND TO_CHAR(etl_dt, 'yyyy-MM-dd hh24:mi:ss') = '2020-09-18 14:15:24'AND type = 'zwf'SELECT * FROM testWHERE 1 = 1AND etl_dt BETWEEN TO_DATE('2020-09-11', 'yyyy-MM-dd hh24:mi:ss') AND TO_DATE('2020-09-18', 'yyyy-MM-dd .

原创 office 2003 office 2007

C:\Program Files (x86)\Microsoft Office\OFFICE11\WINWORD.EXE

原创 data warehouse

原创 oracle batch insert

SELECT * FROM test;INSERT ALL INTO test VALUES ('005129', 'zwf') INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test VALUES ('005128', 'zff')INTO test V.

原创 .webframe.core.struts2.WebFrameValidateExceptionInterceptor.doIntercept(WebFrameValidateExceptionInt

.webframe.core.struts2.WebFrameValidateExceptionInterceptor.doIntercept(WebFrameValidateExceptionInterceptorThread "WebContainer":18"(0000010e) has been active for 648139 milliseconds and may be hung.

原创 axure wow game

克苏恩布局图

原创 ORA-08103:object no longer exists

ORA-08103:object no longer existsselect obj#,dataobj#,name,type#,owner# from obj$ where name = 'TEST';select object_name,object_type,object_id,data_object_id from user_objects where object_name = 'zwf';暂时未解决触发!

原创 org.apache.commons.dbcp.BasicDataSource password

原创 oracle query by date

CREATE TABLE test(name VARCHAR2(200),etl_dt DATE);SELECT * FROM test WHERE TO_CHAR(ETL_DT, 'yyyy-MM-dd') = '2020-03-31';