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

What is scope of pl sql developer in future?

602

---

What information is needed to connect sql*plus an oracle server?

596

---

Is sql harder than python?

620

---

Advantages and disadvantages of stored procedure?

592

---

Can you have a foreign key without a primary key?

517

---

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1726

---

What is rownum?

546

---

Can we create index on primary key?

537

---

What is the purpose of a secondary key?

519

---

What are the properties of a transaction?

584

---

what is a join? : Sql dba

572

---

What is the reports view in oracle sql developer?

555

---

How to return multiple rows from the stored procedure?

528

---

What is acid property in a database?

593

---

How to write html code in pl sql?

588

---