Answer Posted / aditi yadav

in addition to above answers -
1. Functions can be called inside procedure but procedure cannot be called inside functons.
2. Functions compiled every time when we call them whereas procedure compiles only once & can be called again and again without being compiled.
3. we can user functions in select statement but cannot use procedure.
4. Inside function we cannot user DML commands but inside procedures we can use DML commands.

Is nosql faster than sql?

970

---

What is auto increment in sql?

1061

---

Can one improve the performance of sql*loader? : aql loader

981

---

What is the syntax to add a record to a table?

1021

---

What is compiled query?

954

---

How do you drop a trigger?

923

---

What is the use of index in sql?

958

---

Do prepared statements prevent sql injection?

897

---

What is a string data type in sql?

958

---

What is where clause in sql?

982

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

953

---

How do I edit a stored procedure?

946

---

What is the difference between delete and truncate statement in sql?

1009

---

What is meant by cursor in sql?

941

---

how to do backup entire database? : Transact sql

1068

---