Answer Posted / gourav

select * from emp(table name)
where rownum = 1 and 30



this query will display the first and last record


for eg rownum start from 1 and rownum last record is 30..by
execute this query u wil get frst and last reord

what is a cursor? : Sql dba

1002

---

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

1058

---

Which are the different types of indexes in sql?

1041

---

Define select, insert, create, delete, update, drop keywords

1035

---

Can I learn sql in a week?

1043

---

How many joins can you have in sql?

918

---

What is mutating trigger?

1003

---

What is normalisation and its types?

988

---

What are the types of dbms?

954

---

Can you load data into multiple tables at once? : aql loader

1056

---

What is difference between sql and oracle?

1096

---

What is plpgsql language?

1036

---

How does sql store data?

890

---

What is rtm stands for?

1077

---

How to run pl sql program in mysql?

997

---