I have a database block on one form and on that block there is one field which needs "multirow validation".
This field "USE_ORDER" is defined so that one of the records on that block needs to have value 1 on it and only one record.
I cannot check this on field validation nor cannot I check this on record level commit processing as there might be a situation like:
Row1: User has changed value 1 -> 0
Row2: User has changed value 0 -> 1
I do not want to allow to user to continue before this situation has been solved.
How this kind of multirow validations are recommended to be handled in Oracle Forms?
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…