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
Explain the use of analyse option in exp command.
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is raw datatype in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to use subqueries in the from clause in oracle?
Difference between pre-select and pre-query
How to revoke create session privilege from a user in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How do I call oracle stored procedures that take no parameters?
Explain the use of show option in imp command.
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is the recommended interval at which to run statspack snapshots, and why?
What is instant client oracle?
How to write text literals in oracle?
What is a oracle database?