Answer Posted / 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 |
Post New Answer View All Answers
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is a primary key? Explain
What is trigger price?
What is the trigger in sql?
Why is partition used in sql?
Can instead of triggers be used to fire once for each statement on a view?
What has stored procedures in sql and how we can use it?
What is the difference between sql and isql*plus?
What are the benefits of stored procedures?
Can we join same table in sql?
What is type and rowtype in pl sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can you do multiple joins in sql?
what is the difference between char and varchar data types? : Sql dba
Can we use commit inside a trigger?
