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

Which nosql database is best?

971

How to select 10 records from a table?

1151

How would you pass hints to the sql processor?

974

How global cursor can be declare with dynamic trigger ?

2199

Can we have two clustered index on a table?

1018

What are sql ddl commands?

1082

Is there any restriction on the use of union in embedded sql?

1150

What are aggregate functions in sql?

1150

discuss about myisam index statistics collection. : Sql dba

941

What is dml with example?

1078

How to revise and re-run the last sql command?

1157

What is right join sql?

957

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1155

Define tables and fields in a database

1124

How does sql developer connect to oracle database?

991