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 the sql query to display the current date?

1089

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1044

What is numeric function sql?

1102

What is substitution variable in pl sql?

1099

What is a recursive stored procedure?

1247

how can we repair a mysql table? : Sql dba

1037

which operator is used in query for pattern matching? : Sql dba

1040

How many types of indexes are there in sql?

1037

Explain mutating table error.

1256

What is the use of partition by in sql?

1043

Can we connect to postgresql using sql developer?

1044

What are all ddl commands?

1125

What is union and union all keyword in sql?

1103

What are field types?

1049

What are the advantages of sql?

1098