What is the Difference between Procedure and Function.Can we
call a Function in a DML?
Answer Posted / sharad kumar
1. Function must return a value like any other Programing
Language.
2.yes we can call function from a DML.Remember count(*),sum
etc...
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
How do I debug a stored procedure?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is the importance of sqlcode and sqlerrm?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Why functions are used in sql?
What are inner outer left and right joins in sql?
what are the different index configurations a table can have? : Sql dba
What are the key differences between SQL and PL SQL?
How do you use a while loop in pl sql?
How to call a javascript function from pl sql?
What is primary key and foreign key with example?
Is hadoop a nosql?
Do foreign keys improve performance?
Can we use views in stored procedure?
What is the use of function in sql?