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 the difference between truncate and drop statements?

1195

---

what are the 'mysql' command line arguments? : Sql dba

1144

---

Can one improve the performance of sql*loader? : aql loader

1052

---

What is self-join and what is the requirement of self-join?

1153

---

What is the difference between sql and isql*plus?

1105

---

What is the use of pl/sql table?

1070

---

Can dml statements be used in pl/sql?

1087

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1073

---

what is 'trigger' in sql? : Sql dba

1090

---

Can we edit a view in sql?

988

---

tell us something about heap tables. : Sql dba

1104

---

What is sqlcontext?

1089

---

What is the syntax to add a record to a table?

1090

---

Which is the correct statement about truncate and delete?

1116

---

What is asqueryable?

980

---