I am trying to construct a trigger that will update Table B with Max value end_date column when the corresponding end_date of table A is updated. This is so I can calculated and save the date …
Tag: database-trigger
How to update attribute based on result of aggregate function
I am new to mySQL. I want to update the order price of a table, based on the value of the retail price and the quantity of the product ordered. I have the following tables (simplified for this …
Disable trigger in another db(Oracle)
Can I create a procedure that disables a trigger in another database? I mean, can I disable it with a database link? I need it for importing data into a data warehouse
Postgresql update specific fields based on a value (trigger)
I am writing a Trigger in Postgresql to update dynamically the content of specific columns of a revenues table based on inserts on a consultations table. [edit] Here is how my tables look like …
SQL – trigger select into after update/insert
i have a table called Audit_Data, and from time to time there is an update coming. Every single update consists of around 300 rows (around 20 columns per row), and all of the rows from the same update …