Answer Posted / shareef

select * from emp where (rowid,0) in(select rowid,mod(rownum,2) from emp);---even


select * from emp where (rowid,1) in(select rowid,mod(rownum,2) from emp);---odd

How much memory your 10g xe server is using?

1087

---

How to calculate date and time differences in oracle?

1021

---

Explain how you would restore a database using RMAN to Point in Time?

2129

---

How to bring a tablespace offline?

1046

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1675

---

How to shutdown your 10g xe server from command line?

1066

---

How to write date and time interval literals in oracle?

1015

---

How to do a full database export?

1085

---

Please explain drop constraint oracle?

1081

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2481

---

List the parts of a database trigger.

1034

---

What happens if you set the sga too low in oracle?

1118

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2045

---

How to write date and time literals in oracle?

987

---

Explain an exception and its types?

1052

---