试一下
CREATE OR REPLACE TRIGGER 触发器名称
AFTER insert
ON A
FOR EACH ROW
BEGIN
UPDATE B SET COUNT=COUNT+1 AND show=1 WHERE ……;
END;
CREATE OR REPLACE TRIGGER 触发器名称
AFTER insert
ON A
FOR EACH ROW
BEGIN
UPDATE B SET COUNT=COUNT+1 AND show=1 WHERE ……;
END;
解决方案 »
- conn / as sysdba与OracleDBConsoleorcl的冲突
- 多张表分组,left join 但是decode只能判断一个字段,我现在需要判断2个的基础上sum,怎么办
- ora-2143 无效的storage选项问题
- 查看ORACLE 11G中的日志文件
- 如何创建一个新的oracle数据库?
- 如何做这样的约束?
- 通过临时表生成查询结果。多人同时访问时如何防止临时表被清空?
- 在操作系统启动的时候不启动Oracle,因为检测很慢,怎么做?
- 新手问题,Oracle 相关概念
- 接触ORACLE已经半年多了,现在想自己实践一个案例,从应用程序到ORACLE数据库,以及中间的接口层,哪里有这样的例子,或者我可以帮助各位
- 模拟自增字段的问题
- 请教SQL 多表关联查询的问题
COUNT=COUNT+1 等号右面是原值,等号左面是新值
修改成下面的,更完善些
UPDATE B SET COUNT=nvl(COUNT,0)+1 AND show=1 WHERE ……;
after insert on NEWS_CLASS
FOR EACH ROW
begin
UPDATE SOFTWARE_INFO SET current_version=nvl(current_version,0)+1 AND name='就医助手新闻类别菜单' AND valid='1' WHERE code='3'; end;为什么UPDATE SOFTWARE_INFO SET current_version=nvl(current_version,0)+1 AND name='就医助手新闻类别菜单' AND valid='1' WHERE code='3'; 报SQL命令未正确结束
//oracle.sql.Clob类型转换成String类型 public String ClobToString(Clob clob) throws SQLException, IOException { String reString = "";
Reader is = clob.getCharacterStream();// 得到流
BufferedReader br = new BufferedReader(is);
String s = br.readLine();
StringBuffer sb = new StringBuffer();
while (s != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING
sb.append(s);
s = br.readLine();
}
reString = sb.toString();
return reString;
}
javax.xml.ws.WebServiceException: Unable to create JAXBContext
at com.sun.xml.ws.model.AbstractSEIModelImpl.createJAXBContext(AbstractSEIModelImpl.java:158)
at com.sun.xml.ws.model.AbstractSEIModelImpl.postProcess(AbstractSEIModelImpl.java:87)
at com.sun.xml.ws.model.RuntimeModeler.buildRuntimeModel(RuntimeModeler.java:262)
at com.sun.tools.ws.wscompile.WsgenTool.buildModel(WsgenTool.java:225)
at com.sun.tools.ws.wscompile.WsgenTool.run(WsgenTool.java:124)
at com.genuitec.eclipse.ws.jaxws.JaxWSBUJob.wsGen(JaxWSBUJob.java:229)
at com.genuitec.eclipse.ws.jaxws.JaxWSBUJob.run(JaxWSBUJob.java:125)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
Caused by: java.security.PrivilegedActionException: com.sun.xml.bind.v2.runtime.IllegalAnnotationsException: 3 counts of IllegalAnnotationExceptions
java.sql.Clob is an interface, and JAXB can't handle interfaces.
this problem is related to the following location:
at java.sql.Clob
at private java.sql.Clob com.service.jaxws.ClobToString.arg0
at com.service.jaxws.ClobToString
java.sql.Clob does not have a no-arg default constructor.
this problem is related to the following location:
at java.sql.Clob
at private java.sql.Clob com.service.jaxws.ClobToString.arg0
at com.service.jaxws.ClobToString
java.lang.StackTraceElement does not have a no-arg default constructor.
this problem is related to the following location:
at java.lang.StackTraceElement
at public java.lang.StackTraceElement[] java.lang.Throwable.getStackTrace()
at java.lang.Throwable
at java.lang.Exception
at java.sql.SQLException
at private java.sql.SQLException com.service.jaxws.SQLExceptionBean.nextException
at com.service.jaxws.SQLExceptionBean at java.security.AccessController.doPrivileged(Native Method)
at com.sun.xml.ws.model.AbstractSEIModelImpl.createJAXBContext(AbstractSEIModelImpl.java:148)
... 7 more
Caused by: com.sun.xml.bind.v2.runtime.IllegalAnnotationsException: 3 counts of IllegalAnnotationExceptions
java.sql.Clob is an interface, and JAXB can't handle interfaces.
this problem is related to the following location:
at java.sql.Clob
at private java.sql.Clob com.service.jaxws.ClobToString.arg0
at com.service.jaxws.ClobToString
java.sql.Clob does not have a no-arg default constructor.
this problem is related to the following location:
at java.sql.Clob
at private java.sql.Clob com.service.jaxws.ClobToString.arg0
at com.service.jaxws.ClobToString
java.lang.StackTraceElement does not have a no-arg default constructor.
this problem is related to the following location:
at java.lang.StackTraceElement
at public java.lang.StackTraceElement[] java.lang.Throwable.getStackTrace()
at java.lang.Throwable
at java.lang.Exception
at java.sql.SQLException
at private java.sql.SQLException com.service.jaxws.SQLExceptionBean.nextException
at com.service.jaxws.SQLExceptionBean at com.sun.xml.bind.v2.runtime.IllegalAnnotationsException$Builder.check(IllegalAnnotationsException.java:102)
at com.sun.xml.bind.v2.runtime.JAXBContextImpl.getTypeInfoSet(JAXBContextImpl.java:438)
at com.sun.xml.bind.v2.runtime.JAXBContextImpl.<init>(JAXBContextImpl.java:286)
at com.sun.xml.bind.v2.ContextFactory.createContext(ContextFactory.java:139)
at com.sun.xml.bind.api.JAXBRIContext.newInstance(JAXBRIContext.java:105)
at com.sun.xml.ws.model.AbstractSEIModelImpl$1.run(AbstractSEIModelImpl.java:153)
at com.sun.xml.ws.model.AbstractSEIModelImpl$1.run(AbstractSEIModelImpl.java:149)
... 9 more