What is difference between Procedures and Functions ?
Answer Posted / roopesh kumar
(1) Procedure may or may not return value but function
should.
(2) We can't call a procedure inside a sql stmt but
function can.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is heap table? : Sql dba
Explian rowid, rownum?
What is count * in sql?
Where not exists in sql?
What does pragma mean?
How do I run a sql query in pgadmin 4?
Why is there a need for sqlcode and sqlerrm variables?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Does view store data in sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
which tcp/ip port does sql server run on? : Sql dba
What is the difference between sql and mysql?
What are its different types of dbms?