display odd / even records
how to delete duplecate record
what are oracle precompilers
their is a % sign in an field of a column , what will be the query to find it

Hi guys

I m ALI an oracle developer from Pakistan

for odd records:

SELECT * FROM emp WHERE ROWID IN ( SELECT DECODE(MOD(ROWNUM,2),1,ROWID) FROM emp );


for even;

SELECT * FROM emp WHERE ROWID IN ( SELECT DECODE(MOD(ROWNUM,2),0,ROWID) FROM emp );


try this hope problem will b solved


thanks

remeber me in pray

display odd / even records
To select ODD record
SELECT max(rownum),empno,ename FROM emp GROUP BY rownum,empno,ename
HAVING mod(rownum,2)<>0

To select Even record
SELECT max(rownum),empno,ename FROM emp GROUP BY rownum,empno,ename
HAVING mod(rownum,2)=0

try this -

DELETE FROM table_name
 WHERE column_name1 IN
( SELECT e.column_name1
  FROM table_name e, table_name f
  WHERE e.column_name1 =f.column_name1 AND   
  e.column_name2=f.column_name2 )