Sajid Ansari

• Jun 24th, 2006

 

SELECT DECODE(MOD(column_name,2),1,1)

FROM table_name

WHERE DECODE(MOD(PTR_ID,2),1,1)=1

jack

• Jul 24th, 2006

 

 

SELECT DECODE(MOD(column_name,2),1,column_name) odd_Numbers

FROM table_name

WHERE DECODE(MOD(PTR_ID,2),1,1)=1

Ratheesh

• Jun 1st, 2007

 

select <column_name> from <table_name> where mod(<column_name>,2)<>0

RAM

• Jun 29th, 2012

 

Select rownum,h.* from scott.emp h
where (rowid,1) in (select rowid,mod(rownum,2) from scott.emp)

Code
SELECT ROWNUM,h.* FROM scott.emp h 


WHERE (ROWID,1) IN (SELECT ROWID,MOD(ROWNUM,2) FROM scott.emp)

RAM

• Aug 8th, 2012

 

SELECT ROWNUM,ENAME,JOB FROM EMP
WHERE MOD(ROWNUM,2)!=0
ORDER BY ROWNUM DECE;

Rahul Kumar Thakur

• Aug 17th, 2012

 

which command will delete all data from a table and will not write to the rollback segment?

Cool_Guy007

 Profile Answers by Cool_Guy007 Questions by Cool_Guy007

• Sep 3rd, 2012

 

truncate table table name... by using this command we can delete all the data from the table which can not be rollback

shivigupta

 Profile Answers by shivigupta Questions by shivigupta

• Oct 9th, 2012

 

set serveroutput on;
begin
for v_c1 in (select num from tab_no) loop
if mod(v_c1.num,2) = 1 then
dbms_output.put_line(v_c1.num);
end if;
end loop;
end;

Rakesh Anand

 Profile Answers by Rakesh Anand 

• Aug 24th, 2013

 

Code
SELECT * FROM (SELECT COLUMN_NAME, ROWNUM RN FROM TABLE)


WHERE MOD (RN, 2) <> 0;

AMRUT SWAGAT DWIVEDY

• Apr 18th, 2014

 

TRUNCATE Query

Code
TRUNCATE table table_name;