Answer Posted / p.rajasekar

Function:
1.Function Always Return values
2.We can call the function in select Query
3.We can return more than one values using Out put
paramaetes
4.Genrally we can use function as calculatevalues
5.We can insert,update or delte value with the help
function in a select query
Procedure:
1.Procedure doesnot always return value
2.We can't call procedure in Select query
3.We can return more than one value using Out put
parameters in procedure
4.Genarally procudures are using as business logic

How to set up sql*plus output format in oracle?

1034

---

What is indexing oracle sql?

1098

---

How do you go back in sql?

985

---

What is gpt format?

936

---

what is 'mysqlimport'? : Sql dba

1044

---

Explain scalar functions in sql?

1063

---

How do you pronounce sql?

1005

---

What are pl sql data types?

1007

---

What is online transaction processing (oltp)?

1015

---

Why do we use function in pl sql?

1058

---

Why do we go for stored procedures?

1053

---

What is $$ in sql?

988

---

What are actual parameters and formal parameters?

1102

---

What is sql mysql pl sql oracle?

1067

---

explain the delete statements in sql

1048

---