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 to run pl/sql statements in sql*plus?

796

how to enter characters as hex numbers? : Sql dba

784

Which join is like an inner join?

757

What is field delimiter?

820

What is the function that is used to transfer a pl/sql table log to a database table?

767

What are the different types of joins in sql?

1220

What is offset in sql query?

877

What is serial sql?

739

What are pl/sql cursors?

760

What is number function in sql?

753

Can I learn sql in a week?

802

what is clause? : Sql dba

797

Is sql free?

703

What is a data definition language?

830

What is varchar example?

793