How to enlarge the size of work area in iSQL*plus?

viji_info

 Profile Answers by viji_info Questions by viji_info

• Oct 22nd, 2010

If you are working isql plus..Go to the preference which lay on the right hand corner, then Edit the column width and height as much you want... Try it.

Answer Question  Select Best Answer

How to fetch alternate rows from the table?

Ram

• Feb 6th, 2013

Code
SELECT * FROM EMP 
WHERE (ROWID,1) IN (SELECT ROWID,MOD(ROWNUM,2) FROM EMP);
 
OR 
 
SELECT * FROM (SELECT EMP.*,ROWNUM K FROM EMP)
WHERE MOD(k,2)=0;

Millar

• Jul 26th, 2012

Code
SELECT * FROM table_name WHERE mod(primary_key_column,2)=0 --to find even rows in a table
 
SELECT * FROM employees WHERE mod(employee_id,2)=0 --to find even rows in a table
 
SELECT * FROM employees WHERE mod(employee_id,2)=1 --to find odd rows in a table

Answer Question  Select Best Answer

Arbind Kumar Singh

• Jul 23rd, 2012

sql query for retrieving last row particular column value depending upon its ID??? QUERY: select top 1 [column_name1],[column_name2] from [table_name] where ID=[ID_value] order by index desc here i...

Ambarish

• Apr 19th, 2012

Select last(column_name) from Table.

Answer Question  Select Best Answer