Answer Posted / suresh babu

select * from table_name tn1 where 5 = (select count(rowid)
from table_name tn2 where tn1.rowid >= tn2.rowid);

This query,which is display the 5th row in table.

How many types of cursors supported in pl/sql?

1093

---

What is use of package in pl sql?

949

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1014

---

What is the difference between sql, mysql and sql server?

1013

---

Difference between truncate, delete and drop commands?

1023

---

How to use sql*plus built-in timers?

1095

---

what is the difference between char and varchar data types? : Sql dba

1000

---

How do I count rows in sql?

947

---

Write a sql query to find the names of employees that begin with ‘a’?

951

---

What are views in sql?

926

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2450

---

What is insert command in sql?

1060

---

Explain sql data types?

1035

---

What is sql trigger example?

998

---

What is a unique constraint?

1012

---