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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql in java?
What are conditional predicates?
Why is a primary key important?
I need a function for a train ticket reservation please answer it thanks in advance
What is a procedure in pl sql?
What is a variable in sql?
What are string functions in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is a schema sql?
what is recursive stored procedure? : Sql dba
Explain the advantages and disadvantages of stored procedure?
Write a sql query to get the third highest salary of an employee from employee_table?
Can we write ddl statements in functions?
Name the operator which is used in the query for pattern matching?
What is the difference between syntax error and runtime error?