/ORAEBS 86.9 G

 查看全文

客户化应用的时候都是在$APPL_TOP 进行，可是它在服务器里面时候哪个目录呢？有什么含义

ORA-12547并不常见？先GOOGLE 一下，得到说是少一个包，可是我查看了我的LINUX 为UPDATE5，且非64位， 如果是LINUX3以下的倒是有下载：

在20% 和66％都可能出现，解决方法：

ORA-20000: %s

Cause: The stored procedure 'raise_application_error' was called which causes this error to be generated.

注：我原先写树形的组织结构的时候可以用这个的 ：见CSDN博客：program.diary

一张表可以自我连接．进行自连接时我们需要一个机制来区别一个表的两个实例． 在FROM clause（子句）中我们可以给这个表不同的别名 - 然后在语句中其它需要使用到该别名的地方用dot（点）来连接该别名和字段名．

PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only

Cause: A pseudocolumn or proscribed function was used in a procedural statement. The SQL pseudocolumns (CURRVAL, LEVEL, NEXTVAL, ROWID, ROWNUM) can be used only in SQL statements. Likewise, certain functions such as DECODE, DUMP, and VSIZE and the SQL group functions (AVG, MIN, MAX, COUNT, SUM, STDDEV, VARIANCE) can be used only in SQL statements.

Action: Remove the pseudocolumn reference or function call from the procedural statement. Or, replace the procedural statement with a SELECT INTO statement; for example, replace bonus := DECODE(rating, 1, 5000, 2, 2500, ...); with the following statement: SELECT DECODE(rating, 1, 5000, 2, 2500, ...) INTO bonus FROM dual;

Creating a DML Trigger
To create (or replace) a DML trigger, use the syntax shown here:

1 CREATE [OR REPLACE] TRIGGER trigger name
2 {BEFORE | AFTER}
3 {INSERT | DELETE | UPDATE | UPDATE OF column list} ON table name
4 [FOR EACH ROW]
5 [WHEN (...)]
6 [DECLARE ... ]
7 BEGIN
8 ... executable statements ...
9 [EXCEPTION ... ]
10 END [trigger name];

PLS-00307: too many declarations of 'to_char' match this call

声明了 v_a varchar2
to_char(v_a, '00');
如果v_a 为number 则没有问题

总帐凭证编号要求 8 转换成08*****

[原创整理,转载注明!!!]

ORA-04091:触发器不能修改触发表的数据:

解决方法

1. 建立一个pl/sql table

2.写一个table level触发,在insert/update/delete 前进行表的index 置0

3.写一个statement level 触发, 记录触发的行rowid 放到step 1里面的pl/sql table

4.写一个table level 触发, 从step1 里面的pl/sql table 来获得rowid ,再用loop 来update

table levle and statement level trigger difference is for each row .如果没有就是statement level trigger

If FOR EACH ROW is specified, then the trigger will activate for each row processed by a statement. If this clause is missing, the default behavior is to fire only once for the statement (a statement-level trigger).