Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16508 Views
- MCN Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / a.jyothsna
1) function can be executed using the sql command
(Ex: select functin_name(args)from dual;)
Procedure can be executed using sql+ command
(Ex: exec procedure_name(args))
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how to analyze tables with 'mysqlcheck'? : Sql dba
Why do we need a foreign key?
- 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?
What is the purpose of design view?
What are the different tcl commands in sql?
What is the difference between pl and sql?
What are user defined functions?
how can we know the number of days between two given dates using mysql? : Sql dba
What is use of term?
What are the disadvantages of file system?
Can we create foreign key without primary key?
how to create a new table in mysql? : Sql dba
Why cross join is used?
What is the purpose of normalization?
Can a varchar be a primary key?
