database-trigger
Why does code throw java.sql.SQLException: ORA-01438?
I\'m inserting data in table through this statement: insert into CATEGORY_MASTER ( CAT_MAS_ID, DESCRIPTION, ORG_ID, STATUS, MODIFY_EMPID, LANGUAGE_ID, LG_IP_MAC)[详细]
2023-03-11 07:02 分类:问答Inserted, Deleted Tables (Magic Tables) in MySQL
I am regular user of MS-SQL but now working on a project which has mysql as a back-end. Please tell me that is ther开发者_如何学Pythone exists such a inserted/Deleted tables (Magic tables) in mysql w[详细]
2023-03-11 03:10 分类:问答Modifying a MySQL Trigger
I have a MySQL trigger that I would like to be modified. The only changes are in the trigger body. Will updating the ACTION_STATEMENT Colu开发者_如何学编程mn in INFORMATION_SCHEMA.TRIGGERS suffice? I[详细]
2023-02-17 16:00 分类:问答Can I execute a cURL call from postgres trigger
I have to create a process call on a db field(s) being a certain status. I have heard you can execute a cURL call with a db trigger but Google is not being kind enough to return anything I can use.[详细]
2023-01-27 07:51 分类:问答How to pick a default value to the column in the trigger?
We implement some triggers which perform some operations with insert dat开发者_如何学Goa before committing them to the database and when some conditions fail the trigger should pick up the default val[详细]
2023-01-15 18:32 分类:问答Can not create Delete trigger because table has a FOREIGN KEY with cascading DELETE
I am trying to create a Delete trigger. I have this navigation table which is called Nemanet_Navigation. The table has a foreign key to itself but when selecting relationship for the table I have in I[详细]
2023-01-11 02:12 分类:问答T-SQL Trigger calling SQLCLR Stored Procedure vs SQLCLR Trigger
Are there any benefits to calling a SQLCLR stored procedure from a regular T-SQL trigger rather than deploying a SQLCLR trigger straight away?[详细]
2023-01-08 09:04 分类:问答How to Copy format from remote CVS to local file eclipse?
I am new to eclipse. I checked in java file from remote CVS.then I modify the file then I compa开发者_如何学Gore with latest from head.[详细]
2022-12-20 18:53 分类:问答