Answer Posted / vamsi nukala

select * from(select rownum as rno,emp.* from emp)where rno=2;

How long it takes to learn pl sql?

951

---

How to fetch alternate records from a table?

1160

---

what is the difference between char_length and length? : Sql dba

993

---

What operating systems are supported by oracle sql developer?

904

---

What is a nested table in word?

911

---

Can we use distinct and group by together?

994

---

Explain commit, rollback and savepoint.

933

---

Explain what is rdbms?

993

---

How do I view an execution plan in sql?

924

---

How to read/write files from pl/sql?

994

---

What are the topics in pl sql?

932

---

What are data types in pl sql?

1077

---

how can you see all indexes defined for a table? : Sql dba

936

---

Is sql a backend language?

1043

---

What is the difference between sql and mysql?

1055

---