Answer Posted / ramaraju

select
ename
from
emp
order by ename
offset 4 rows
fetch next 5 rows only;

try this answer oracle 12c introduced offset fetch rows.

tell us something about heap tables. : Sql dba

1105

---

How do I install microsoft sql?

1061

---

What is coalesce sql?

1010

---

What is a full join sql?

1064

---

What are the types of optimization?

966

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1060

---

What is pl/sql table? Why it is used?

1046

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2092

---

What are different functions in sql?

951

---

How to convert comma separated string to array in pl/sql?

1195

---

what does the t-sql command ident_current does? : Transact sql

989

---

What is cold data?

966

---

what are null values? : Sql dba

964

---

What is a sql driver?

1006

---

what is the difference between char_length and length? : Sql dba

1053

---