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

What are the built in functions of sql?

783


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1028


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

978


What are the types of sql commands?

788


What is the difference between null value, zero, and blank space?

822


What does count (*) do in sql?

759


how to concatenate two character strings? : Sql dba

782


what are the properties and different types of sub-queries? : Sql dba

743


What is primary key and unique key?

801


how to include numeric values in sql statements? : Sql dba

803


Which one is better subquery or joins?

813


What are pl sql procedures?

736


What is dynamic sql in pl sql?

733


What is left join in postgresql?

795


Which join is default?

730