Answer Posted / lavanya

functions:
1.The parameters are input values and output values
2.The functions will return a value
3.The functions will be called with in sql

Procedures:
1.The parameters are input values and output values
2.The procedures will not return any value
3.The procedures will not be called with in sql

Does oracle use sql?

913

---

How to connect a sql*plus session to an oracle server?

1114

---

What is a join?

1049

---

What are system versioned tables?

1011

---

What are the properties of a transaction?

1121

---

is it possible to pass an object or table to a procedure as an argument?

1108

---

what is the difference between cluster and non cluster index? : Sql dba

1008

---

How show all rows in sql?

1000

---

What are the limitations of sql express?

1050

---

Explain clause in sql?

1011

---

How to install oracle sql developer?

1024

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1564

---

What is the max nvarchar size?

947

---

What is the difference between an inner join and an outer join?

1005

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2008

---