What are crud methods?

0 Answers  

---

What is recursive stored procedure?

0 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---

What is the difference between row level and statement level trigger?

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 does truncate mean in sql?

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What is cursor and its types?

0 Answers  

---

Write the command to remove all players named sachin from the players table.

0 Answers  

---

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

---

Can we write ddl statements in functions?

0 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---