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

What is rownum in sql?

981

List the ways to get the count of records in a table?

864

Which is faster view or stored procedure?

895

Is primary key a clustered index?

926

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1006

Explain unique key in sql.

953

What is sql resultset?

938

Why do we use joins in sql?

919

What is a temporal table?

894

What is data modelling in sql?

972

Why is pl sql used?

948

What are all the different types of indexes?

1097

Is not equal in sql?

966

What is the difference between sql, mysql and sql server?

1028

How to create your own reports in sql developer?

985