APEX19 of 30: Uniqueness constraint on 2 columns. Page item calculation to convert text case.
If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files used in this video series. https://sites.google.com/view/db-krei...
APEX 18.1 video 19 of 30: Add a column to the lookup table so it can reference another table for cascading LOVs. For example, each breed is associated with an animal category, such as collie is associated with canine. Add a uniqueness constraint for animal category and dominant breed so that collie and canine can’t be entered more than once in the lookup (reference) table. Create a report with form for each lookup (reference) table. If needed, convert text to uppercase for reference data and enforce uppercase for text entered in the form.
Watch video APEX19 of 30: Uniqueness constraint on 2 columns. Page item calculation to convert text case. online without registration, duration hours minute second in high quality. This video was added by user J Kreie Database 08 November 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,572 once and liked it 16 people.