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)

What is rename in sql?

0 Answers  

---

Does sql view stored data?

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,

---

what is a join? : Sql dba

0 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

using comand prompt how can import table data and table space with example

2 Answers  

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

What is percent sign in sql?

0 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

How insert into statements in sql?

0 Answers  

---

What is the use of procedures?

0 Answers  

---

What are the disadvantages of not performing database normalization?

0 Answers  

---