Quick Inquiry

Oracle using MOD command to set Y/N on INSERT in SQL ?

Yogesh Kumar
04-May-2022
0

Oracle using MOD command to set Y/N on INSERT in SQL ?

Use decode() (or case), like this:

 decode(mod(rownum,5),0,'N','Y') as active

53 0 7

Write a Comments

* Be the first to Make Comment

Fix Your Meeting With Our SEO Consultants in India To Grow Your Business Online