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 ...

Does pl sql work in mysql?

923

---

What is a trigger in sql?

1158

---

Can we call stored procedure in function?

905

---

Is progress software supports to ( pl/sql )?

973

---

Can we insert data into view?

850

---

Why we use pl sql?

908

---

What operators deal with null?

1031

---

What is rtm stands for?

1023

---

Explain polymorphism in pl/sql.

1059

---

What is varray in pl sql?

1008

---

How do I find duplicates in two columns?

1060

---

What is pl sql quora?

1072

---

what is a database lock ? : Sql dba

1093

---

What is pl sql and why it is used for?

1073

---

how to rename an existing column in a table? : Sql dba

962

---