Answer / srihari

formal parameters used in declare section and actual parameters used in begin or executable section.

What are the composite date types in oracle?

6 Answers   HCL,

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

How to use "in out" parameter properly?

0 Answers  

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 Answers  

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

Differentiate between pre-select and pre-query?

0 Answers  

---

what is candidate key & super key

1 Answers  

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---

What happens to the data files if a tablespace is dropped?

0 Answers  

---

How to store only time; not date and time?

0 Answers  

---

What is an oracle transaction?

0 Answers  

---

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

2 Answers   Cognizant,

---