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
What is compiled query?
Can delete statement be rollbacked?
What is a loop in sql?
Do stored procedures prevent sql injection?
Mention what does the hierarchical profiler does?
Explain what is a subquery ?
What schema means?
What is set transaction?
What are the events on which a database trigger can be based?
what is the difference between group by and order by in sql? : Sql dba
List the various privileges that a user can grant to another user?
Which is faster truncate or drop?
What is an intersect?
Mention what are the benefits of pl/sql packages?
How can you tell the difference between an index and a view?