TrimwebsolutionsProblem and Solutions
Oracle using MOD command to set Y/N on INSERT in SQL ?
By M.K. Verma · 4 May 2022
Use decode() (or case), like this:
decode(mod(rownum,5),0,'N','Y') as activeAdvertisement
Problem and Solutions
By M.K. Verma · 4 May 2022
Use decode() (or case), like this:
decode(mod(rownum,5),0,'N','Y') as active