Answer Posted / sachin

select distinct(sal) from employee order by sal desc limit 2,1;

Explian rowid, rownum? What are the psoducolumns we have?

555

---

Explain the savepoint statement.

594

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

665

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

587

---

What is varchar example?

562

---

---

What is the difference between a database and a relational database?

558

---

What are aggregate and scalar functions?

519

---

Can you selectively load only those records that you need? : aql loader

605

---

What is difference sql and mysql?

522

---

Can we use view in stored procedure?

495

---

What is sql scripting?

549

---

How many types of literals are available in pl sql?

506

---

What is faster join or subquery?

502

---

What is sql integrity?

575

---

Does view store data in sql?

525

---