Answer Posted / 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 |
Post New Answer View All Answers
Why partition by is used in sql?
What are literals in sql server?
How do I count rows in sql query?
What are character functions in sql?
What is data modelling in sql?
Are left and right joins the same?
Compare sql & pl/sql
What are the different types of a subquery?
what is a foreign key ? : Sql dba
Does mysql support pl sql?
How do you optimize a stored procedure query?
Why we use pl sql?
What are the parts of a sql statement?
What is integrity in sql?
What is a constraint? Tell me about its various levels.
