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 are the properties and different types of sub-queries? : Sql dba

1027

---

what are the differences between char and varchar? : Sql dba

1063

---

What is dense_rank in sql?

966

---

Can delete statement be rollbacked?

980

---

Can you do multiple joins in sql?

1039

---

How to call a javascript function from pl sql?

1128

---

Explain the difference between 'between' & 'and' operators in sql

992

---

What is coalesce in sql?

1048

---

How to avoid using cursors?

1112

---

What are the types pl/sql code blocks?

1121

---

What are the uses of sysdate and user keywords?

1095

---

If a cursor is open, how can we find in a pl/sql block?

1154

---

How many subqueries can be nested in a statement?

978

---

What is a column in a table?

1115

---

What is normalization? How many normalization forms are there?

1079

---