Answer Posted / anudeep

select * from employee where rowid=&n;

How can you fetch first 5 characters of the string?

555

---

What is sql*loader and what is it used for?

582

---

What are the different datatypes available in PL/SQL?

571

---

How do you go back in sql?

535

---

what is an index? : Sql dba

529

---

---

What is the largest value that can be stored in a byte data field?

521

---

What is data type in sql?

558

---

What is the benefit of foreign key?

529

---

What is parameter substitution in sql?

530

---

Is a foreign key always unique?

536

---

What are the differences between implicit and explicit cursors?

524

---

Is sql dba a good career? : SQL DBA

539

---

What is a natural join sql?

515

---

What is difference between stored procedures and application procedures?

574

---

Can you sum a count in sql?

563

---