what is difference between procedure and function

Answer Posted / suresh

Function is return the value
procedure is not return the value

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key a clustered index?

720


Explain clause in sql?

774


What are all the ddl commands?

895


Which sorts rows in sql?

797


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1606


How to know the last executed procedure?

837


How to handle bulk data?

1081


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

876


What are database links used for?

783


How to start the command-line sql*plus?

775


Is it possible to create startup or shutdown trigger for on-schema?

805


Can sql function call stored procedure?

787


What is cascade in sql?

724


What is the difference between pl and sql?

767


How does rowid help in running a query faster?

1178