Answer Posted / sudama maharana

1. Stored procedure is loaded to database once it compiled, but inline queries are not loaded in to server. So, Stored procedure is in compiled form.

2. As Stored procedure is in compiled form, so in each calling to it, it takes less time than inline queries. Because in Stored procedure we are passing only the names, but in inline query we are passing the whole query.

3. Stored procedures are compiled only once and in each calling its only executing the query. But inline queries are compiled & executed in each calling. So, in stored procedure network Traffic is less.

4. In stored procedure, we can pass parameters . But in inline query we can't pass.

Thanks

What is the difference between partition and index?

966

---

what is the difference between primary key and unique key? : Sql dba

1015

---

What is varchar used for?

1068

---

Which is faster truncate or drop?

1029

---

What does an inner join do?

1158

---

Is sql considered coding?

1024

---

What are the packages in pl sql?

997

---

Define overloaded procedure?

1056

---

Why do we need cursor in pl sql?

1120

---

Is postgresql a nosql database?

1139

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1090

---

Explain the the update statement in sql?

1013

---

what is 'mysqldump'? : Sql dba

1092

---

What is exit statement?

999

---

What is left inner join in sql?

1022

---