Keeping a journal in Oracle
The idea is actually quite simple. Whenever a record in a table (here: employee) is updated with a new value in a field (here: salary), a trigger gets fired. This…
The idea is actually quite simple. Whenever a record in a table (here: employee) is updated with a new value in a field (here: salary), a trigger gets fired. This…
This note provides an example on a trigger. I like this example as it shows how additional business logic can be implemented. It is an example of a statement trigger:…
Oracle has a package that allows you to write to a file. Oracle uses the concept of a directory (here “External”) that acts as a logical description of a directory.…