Answer Posted / swastik mohanty
--TO FIND EVEN NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWNUM, 2), 0, ROWID, NULL) FROM Table);
--TO FIND ODD NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWID, 2), 1, ROWID, NULL) FROM Table);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is index-organized table in Oracle?
Is a rollback possible to any savepoint?
What privilege is needed for a user to create tables in oracle?
what is port in oracle? how is it related to database application.
What do you mean by a deadlock?
What do you mean by a tablespace?
What is a named program unit?
Can the query output be sorted by multiple columns in oracle?
What is the best way to do multi-row insert in oracle?
What is oracle rowcount?
What is a user account in oracle?
What is Data Dictionary Cache in Oracle?
How to download oracle database 10g xe?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is a server parameter file in oracle?
