alexa

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

371 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

Facebook
Twitter
LinkedIn
Instagram
Whatsapp
Call Now
Quick Inquiry