Answer Posted / nagesh

SELECT * FROM EMP WHERE ROWNUM<=10 ORDER BY ENO;

Why do we need cursor in pl sql?

658

---

How show all rows in sql?

621

---

What is the maximum size of sqlite database?

553

---

How do you go back in sql?

543

---

How to read/write files from pl/sql?

592

---

---

What is prepared statement in sql?

558

---

what is try_catch block in procedure

1197

---

How does one load ebcdic data? : aql loader

662

---

Why do we need databases?

578

---

What are character functions in sql?

506

---

How many indexes can be created on a table in sql?

503

---

What is clause?

618

---

how to create a new view in mysql? : Sql dba

508

---

which operator is used in query for pattern matching? : Sql dba

556

---

How do you optimize a stored procedure in sql?

511

---