ora-04091
Oracle calculate average using a trigger
For a school project we are forced to have redundant information and update it by using triggers. We have a table called \'recipe_ratings\' that contains a \'rating\' (numbers 0-100). In our \'recipes[详细]
2023-03-02 08:29 分类:问答Simple oracle triggers
Simple one. I´m a bit of a newvbie with PLSql and oracle\'s error messages are never too helpful. I want to do a simple trigger to update a column with the current date i.e. \'modified date\' column[详细]
2023-01-16 02:49 分类:问答Delete rows matching substring with LIKE?
How do you delete rows from a table, where a column contains a substring, but the type of that column is \'Long\'. (Yes, I开发者_如何学Go know I shouldn\'t use Long, but I\'m maintaining someone else\[详细]
2022-12-21 19:27 分类:问答Oracle triggers - problem with mutating tables
My tables: TableA (id number, state number) TableB (id number, tableAId number, state number) TableC (id number, tableBId number, state number)[详细]
2022-12-17 08:34 分类:问答ORA-04091 on Create or Replace Trigger xxx Before Insert of Update on xxx
Can someone help me correct the Trigger below? I am assigned this problem but my technical skill is limited.[详细]
2022-12-09 19:15 分类:问答