1)we can write COMMIT in procedure but we cant write in function 2) func

diff b/w function and procedure?

Question Posted / tilak

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

Please Help Members By Posting Answers For Below Questions

How do you delete a table?

997

What does where 1/2 mean in sql?

1007

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

898

What does the acronym acid stand for in database management?

983

Does sql profiler affect performance?

940

How many clustered indexes can be created on a table?

1022

how do you login to mysql using unix shell? : Sql dba

1016

What are the ddl commands?

948

What is a full join?

911

Why are cursors used?

1057

how are mysql timestamps seen to a user? : Sql dba

1048

How many types of tables are there?

900

What is user in sql?

967

Can two tables have same primary key?

916

What is bind reference and how can it be created?

965