Answer Posted / chiru

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

What is input buffer in sql*plus?

646

---

tell me about various levels of constraint. : Sql dba

532

---

Can we rollback after truncate?

566

---

How delete all records from table in sql?

555

---

What is procedure and function in sql?

534

---

---

how to shut down the server with 'mysqladmin'? : Sql dba

549

---

Is sql a oracle?

527

---

What are joins in sql?

541

---

what is a database? : Sql dba

610

---

What is a null value?

659

---

How do I start sql from command line?

537

---

How many sql commands are there?

676

---

Why do we need cursors in pl sql?

523

---

Is join and inner join the same?

543

---

What is varchar data type in sql?

520

---