alexa
Facebook
Twitter
LinkedIn
Instagram
Whatsapp
Call Now
Quick Inquiry

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

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

321 0
7

Write a Comments


* Be the first to Make Comment

GoodFirms Badge
GoodFirms Badge

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