Answer Posted / mritunjay

hi..mr guru all are correct except for the Ntn row
Odd number of records:
select * from emp where (rowid,1) in (select rowid,
mod(rownum,2) from emp);
Output:-
1
3
5
Even number of records:
select * from emp where (rowid,0) in (select rowid,
mod(rownum,2) from emp)
Output:-
2
4
6
For nth number,
Example we r considering number n=10
select * from emp where (rowid,1) in (select rowid,
rownum/:N) from emp)

Which software is used for pl sql programming?

1034

---

What are the different set operators available in sql?

1080

---

What are the subsets of sql?

1196

---

what is a constraint? Tell me about its various levels. : Sql dba

1049

---

What is vector point function?

1095

---

What program will open a mdb file?

1020

---

How do you drop a trigger?

1037

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2497

---

What is the maximum number of columns in sql table?

1229

---

What is difference between stored procedures and application procedures?

1067

---

Define tables and fields in a database

1177

---

What are the sql versions?

1000

---

how to run 'mysql' commands from a batch file? : Sql dba

1170

---

How do you know if a relationship is 2nf?

994

---

Can we rollback after truncate?

1072

---