HomeBlogOracle using MOD command to set Y/N on INSERT in SQL ?Problem and SolutionsOracle using MOD command to set Y/N on INSERT in SQL ?By M.K. Verma · 4 May 2022Use decode() (or case), like this: decode(mod(rownum,5),0,'N','Y') as activeShare this:CommentsLeave a commentPost
Trimwebsolutions