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


Please Help Members By Posting Answers For Below Questions

How does cross join work in sql?

527


What are the topics in pl sql?

511


What is difference between db2 and sql?

522


What is transaction control language (tcl)?

625


Is sql easier than java?

516






How do you rename a table in sql?

526


Whis is not false in primary key?

968


What does where 1 1 mean in sql?

535


What is sqlca in powerbuilder?

554


how to convert character strings to dates? : Sql dba

514


Difference between truncate, delete and drop commands?

552


explain mysql aggregate functions. : Sql dba

541


Does sql view stored data?

528


What is the difference between an inner join and an outer join?

508


What is scalar function?

560