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 trigger in pl sql?
What is sql basics?
Explain the difference between 'between' & 'and' operators in sql
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How can use stored procedures in sql?
What is the order of sql select?
How do I start sql profiler?
Is coalesce faster than isnull?
what are the different type of normalization? : Sql dba
How do I truncate a sql log file?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is user in sql?
Does sql use python?
What does inner join mean?
Are dml statements autocommit?