Answer / tathagoto

query will be compiled each time excution
stored procedure will be compiled once and after that it
will execute when it will be called....

Answer / srao

Query is nothing but a single statement to retrieve data
from one or more tables.

Procedure is nothing but the combinations of Different
queries.

Answer / khushbu wadhwani

in procedure one time compilation is done,whereas in query
compilation is done everytime.so,procedure improves
efficiency & performance

Answer / r.s.chauhan

Sp gets stored at the server side where as Not necessary
for query(It can be from application or Clint(sql oem) etc)

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

what is definer rights invoke rights?

1 Answers  

---

What is left join example?

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

What are the types of join in sql?

0 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---

What are the set operators in sql?

0 Answers  

---

What is auto increment feature in sql?

0 Answers  

---

What does seeding a database mean?

0 Answers  

---

Can a table contain multiple foreign key’s?

0 Answers  

---

Can you join a table to itself?

0 Answers  

---