Wednesday, December 20, 2017
Oracle Flags Validation
In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,
Validate a database flag.
One way to handle flag validation is to create a program unit of type function to return the stored value of flag from Oracle database table.
you can customize the returned value from your flag according to the notation you pre-determined for your application business logic.
The following function returns a single value of the stored database flag. There are two or more possible values e.g. (1 or 0) Or (Y or N) but what we concern of is to get the current value of the selected flag according to the given condition in the database.
Then, we can raise an exception or change some item properties to validate user in-put.
Hence, the returned Boolean value from the program unit is just for the validation process. It has nothing nothing to do with the actual value of the database flag. Here is an example to reveal such a confussion.
Learn more about:
Hope this helps...
My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance