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 sql in java?

1065

---

What are conditional predicates?

1034

---

Why is a primary key important?

1025

---

I need a function for a train ticket reservation please answer it thanks in advance

1006

---

What is a procedure in pl sql?

1195

---

What is a variable in sql?

981

---

What are string functions in sql?

1220

---

What is the starting oracle error number? What is meant by forward declaration in functions?

972

---

What is a schema sql?

1126

---

what is recursive stored procedure? : Sql dba

971

---

Explain the advantages and disadvantages of stored procedure?

1133

---

Write a sql query to get the third highest salary of an employee from employee_table?

1057

---

Can we write ddl statements in functions?

1095

---

Name the operator which is used in the query for pattern matching?

930

---

What is the difference between syntax error and runtime error?

1119

---