diff b/w function and procedure?

Answer Posted / muhammad sohail

function can be use in select clause and where clause
procedure can't

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many times can we commit in a loop?

791


What do you mean by field in sql?

864


Is sql low level language?

809


How do I copy a table in sql?

745


Can we commit in trigger?

751


Is id a reserved word in sql?

923


What are transaction and its controls?

784


what does it mean to have quoted_identifier on? : Sql dba

952


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

1041


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2246


Does oracle roll back the transaction on an error?

822


what are the differences between char and nchar? : Sql dba

873


How can I tell if sql is running?

825


What is rank dense_rank and partition in sql?

789


Can primary key be changed?

709