Answer Posted / uday

Sp is nothing but Group of T-Sql Statments compiled into a
single execution plan.

Sy: create procedure Pname

{@parameter1 datatype,@parameter2.........)
as

SQL Statments

end

Plz let me know if i am wrong
uday_testing@yahoo.co.in

what are string data types? : Sql dba

518

---

Differentiate pl/sql and sql?

565

---

What is sqlca in db2?

536

---

what is a unique key ? : Sql dba

547

---

Can sql function call stored procedure?

562

---

---

What is difference between table and view?

531

---

Can pl sql procedure have a return statement?

552

---

What is rank () in sql?

536

---

What is bulk collect in pl sql?

535

---

Why do we use procedures?

519

---

Why do we use cursors?

515

---

Explain what is sql*plus?

670

---

What is index example?

562

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

910

---

how can we destroy the cookie? : Sql dba

561

---