what is difference between procedure and function
Answer Posted / shanmukha srinivas
procedure can run in sql block like
begin
sp_procedure_name(input parameters);
end;
function can run in sql block like
select sf_function_name(input paramters)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is not equal in sql?
Is sql a backend language?
what is data integrity? : Sql dba
What is set transaction?
What is a left inner join?
How do you get column names only for a table (sql server)?
What is string data type in sql?
when is the use of update_statistics command? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
how to run 'mysql' commands from a batch file? : Sql dba
Explain polymorphism in pl/sql.
what is the syntax used for partition in tsql? : Transact sql
What is function and procedure in pl sql?
what tools available for managing mysql server? : Sql dba
Why do we create views in sql?