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 is gpt format?

508

---

What is an inner join sql?

549

---

Show the cursor attributes of pl/sql.

612

---

What are the basic techniques of indexing?

577

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

500

---

---

What is the maximum rows in csv?

487

---

What are the different types of tables in sql?

487

---

What is sql*plus?

573

---

What is the main reason behind using an index?

556

---

How is data stored in sql?

551

---

What are the different datatypes available in PL/SQL?

568

---

How many types of index are there?

553

---

How do I edit a stored procedure?

556

---

What is trigger point?

539

---

What is a boolean in sql?

526

---