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 scope of pl sql developer in future?

799

What is a recursive stored procedure?

898

how to dump a table to a file with 'mysqldump'? : Sql dba

806

How many aggregate functions are available there in sql?

770

Why do we create views in sql?

849

What are few of the schema objects that are created using PL/SQL?

775

Can unique keys be null?

710

Do we need to create index on primary key?

688

Can I join the same table twice?

806

how can we know the number of days between two given dates using mysql? : Sql dba

818

Is sql open source?

765

What are views in sql?

765

what is cursor. write example of it. What are the attributes of cursor.

1044

what are the differences between binary and varbinary? : Sql dba

772

What are variables in pl sql?

860