What is the output of the following query?
select * from Person where rowid in (select decode(mod(rownum,2),0,null, rowid) from Person)

 Posted by Kmandapalli on 1/22/2014 | Category: Oracle Interview questions | Views: 2540 | Points: 40

When you want to select records that contain row id with odd number, then you need to execute this query.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response