diff b/w function and procedure?
Answers were Sorted based on User's Feedback
Answer / rupesh
function must return value whereas procedure may or maynot
return value
Call to Function can be encounter by using select
statement where as procedure can not be call in select
statement
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / muhammad sohail
function can be use in select clause and where clause
procedure can't
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vipin kumar (m.c.a)
For calling both have the different method--
To call function
variablename:=functionname(arguments);
To call procedure
procedurename(argumentlist);
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / tilak
1)we can write COMMIT in procedure but we cant write in function
2) function must me return a value but procedure may or may
not be
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / vishal
procedure have two type of parameter intput and output type
but function have only one
Is This Answer Correct ? | 9 Yes | 6 No |
Answer / sankaranarayanan.c
Procedure return more than one value, but fuction can
return only on value.
Is This Answer Correct ? | 6 Yes | 5 No |
Answer / gourvendra singh
A procedure a subprogram used to perform a specific action
whereas a function is a subprogram which is used to compute
a value,in procedure we can use parameters(IN,OUT,IN OUT)
but in function we cant
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / sanjai yadav
function must have return type but a procedure may or may not have return type?
function:- int a= sum();
procdure:- sum();
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / malkeet kaur
1)functions may or may not have return type but procedure doesn't have return type
2)functions are called from select statement but procedure can not called from select statement
3)fuctions are used when some data is passed to calling environment but procedure is used
when some processing to be done
Is This Answer Correct ? | 0 Yes | 0 No |
Write a unique difference between a function and a stored procedure.
which tcp/ip port does sql server run on? : Sql dba
What is primary key sql?
What does the sign mean in sql?
what is an associative array with example?
What is cartesian join in sql?
Is sql a microsoft product?
how to convert dates to character strings? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
Can we call procedure in select statement?
what is global variable in pl/sql
How do I add a primary key to a table?