Answer Posted / tulasi ravi kumar

hi this tulasi .....+91-9951123501
in SQL Server 2000 we write as...
declare CurTemp scroll cursor for
select top 2 * from <table_name>
open CurTemp
fetch last from CurTemp
close CurTemp
deallocate CurTemp;

in ORACLE , we can write as..

select * fom <table_name>
where rowid=(select rowid from <table_name>where rownum<=2
minus
select rowid from <table_name>
where rownum<2;

so try it ...

What is denormalization in a database?

1052

---

How to install oracle sql developer?

1042

---

Can we insert delete data in view?

950

---

What is set serveroutput on?

1131

---

what is the difference between join and union? : Sql dba

1111

---

How many types of privileges are available in sql?

1345

---

what is the difference between where clause and having clause? : Sql dba

996

---

Which command is used to delete a trigger?

1326

---

Why partition by is used in sql?

1038

---

What are few of the schema objects that are created using PL/SQL?

1030

---

List the different type of joins?

1059

---

What are the basic sql commands?

1086

---

What is the difference between Union and Union all. Which is faster.

1401

---

What is the max nvarchar size?

962

---

How can we debug in PL/SQL?

1131

---