oracle如何删除包含特殊字符的触发器? [英] How to delete trigger in oracle that contain special character?

问题描述

我不知道为什么在数据库中有两个名为crazy'BIN $ 7cCqyWWLJxbgQAEPUFlF + g == $ 0'，'BIN $ 7cK199OiZ4jgQAEPUFkgKA == $ 0'的触发器，然后尝试

I don't know why in the database there are 2 triggers with name crazy 'BIN$7cCqyWWLJxbgQAEPUFlF+g==$0', 'BIN$7cK199OiZ4jgQAEPUFkgKA==$0' and try

DROP TRIGGER BIN$7cCqyWWLJxbgQAEPUFlF+g==$0; 

但是我不能，因为名字有一个'+'

but I can't because the name have a '+'

如何删除这些触发器?，我使用的是oracle 10g

How Can delete these triggers?, i use oracle 10g

推荐答案

它已经被丢弃，并位于回收站中，如果您确实需要，可以清除它.

It's already dropped and in the recycle bin, which you can purge if you really need to.

这篇关于oracle如何删除包含特殊字符的触发器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！