Answer / barun

Function-1.function used for calculation perpose.it must
return value.(call by pl/sql code block,by sql query)

Procedure-it is used to implement business logic.it may or
not return value.it pre compile and stored in server data
base.so it is faster.(call by pl/sql code block_

trigger-it is used to implement business logic and maintain
intigrity.it cant take any para-meter like fun or
procedure.it is automatically fired(implicitely)

how to drop an existing view in mysql? : Sql dba

0 Answers  

---

What is difference between primary and secondary key?

0 Answers  

---

What is difference between sql and oracle?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

Can we perform dml in function?

0 Answers  

---

---

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

---

how to retrive only second row from table?

31 Answers   IBM,

---

What is difference between pls_integer and integer?

0 Answers  

---

How do I upgrade sql?

0 Answers  

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

What is a primary key? Explain

0 Answers  

---