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

How many sectors are in a partition?

1027

---

How to look at the current sql*plus system settings?

1076

---

What does bitemporal mean?

1009

---

What is difference between stored function and application function?

1096

---

What is use of package in pl sql?

945

---

what are different types of keys in sql?

1063

---

how can we destroy the cookie? : Sql dba

955

---

how to install mysql? : Sql dba

1041

---

What is the maximum database size for sql express?

958

---

List the different type of joins?

993

---

how to return query output in html format? : Sql dba

1018

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1001

---

Does pl sql work in mysql?

918

---

How do I run a script in sql developer?

894

---

What will you get by the cursor attribute sql%found?

896

---