Skip to content
Advertisement

Tag: mod

Oracle using MOD command to set Y/N on INSERT

I’m trying to generate some sample data for the following table see below. I have functions that can generate a random DATE and timestamp within a date range, which is working fine. I want to use the MOD command to populate the active field to ‘Y’ OR ‘N’. I want to set every row to active=’Y’ except for every 5th

Advertisement