Answer Posted / chiru

select * from (select rownum r ,a.* from emp a ) where r between 5 and 9

Is pl sql a scripting language?

588

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

902

---

How do I edit a trigger in sql developer?

537

---

Is oracle sql free?

536

---

How do I count rows in sql?

557

---

---

What is a call statement? Explain with an example.

545

---

Compare sql & pl/sql

605

---

tell us something about heap tables. : Sql dba

596

---

What is dialect in sql?

523

---

What is foreign key in sql with example?

511

---

What is the file extension for sql database?

515

---

Does sql*plus also have a pl/sql engine?

558

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

571

---

How to rename a column in the output of sql query?

533

---

What is mutating error in pl sql?

545

---