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: 2297 | Points: 40

Answer:

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

Bookmark It

< Previous : What is the return type of @@Fetch_Status Function ...

Next > : What is the output of the query, select * from P ...

More Interview Questions by Kmandapalli

Latest Interview Questions