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
how to dump a table to a file with 'mysqldump'? : Sql dba
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
what are the security recommendations while using mysql? : Sql dba
How many postgresql users are there, worldwide?
What is an oracle stored procedure?
what is timestamp in mysql? : Sql dba
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
what is blob? : Sql dba
Is progress software supports to ( pl/sql )?
What is a recursive join sql?
Does sql use python?
Why do we use %rowtype & %type in plsql?
Can you sum a count in sql?
how to fetch alternate records from a table? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader