how to convert numeric values to character strings? : Sql dba

0 Answers  

---

Which is the correct statement about truncate and delete?

0 Answers  

---

define sql delete statement ? : Sql dba

0 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

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

0 Answers  

---

---

How can you load multi line records? : aql loader

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is a variable in sql?

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

---

Can a trigger call a stored procedure?

0 Answers  

---

What is constant in pl sql?

0 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---