How to retrieve odd and even number of rows from a table?

Sabbir

• Aug 17th, 2015

What programming language is this? Can you please provide this code in PHP ?

venkat

• Jun 27th, 2012

Code
SELECT * FROM (SELECT rownum rn,col1,col1 FROM table_name) WHERE mod(rn,2)=0

union all

Code
SELECT * FROM (SELECT rownum rn, col1,col2 FROM table_name) WHERE mod(rn,2)=1;

Answer Question  Select Best Answer

how can you generate the system _generate number in forms automaticallyhint: IN FORMS WE CREATING ONE DATA BLOCK BUT ONE CLOUMN (EMPLOYEE_ID) THIS COLUMN GENERATE THE ID NUMBER AUTOMATICALLY WITH OUT CREATING SEQUNENCE

usmanahmad

 Profile Answers by usmanahmad Questions by usmanahmad

• Aug 18th, 2008

1: EMPLOYEE_ID := DBMS_RANDOM.STRING('X',6); ---- its generates unique EMPLOYEE_ID six char long 2: Then check whether newly generated id is already in DB. Create a cursor which select and return ids ...

Answer Question  Select Best Answer