Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16169 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
What are aggregate and scalar functions?
How do you bind variables in pl sql?
what is a constraint? Tell me about its various levels. : Sql dba
what is cursor. write example of it. What are the attributes of cursor.
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is pragma in pl sql?
what is 'mysqlshow'? : Sql dba
What is auto increment in sql?
What is exit statement?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is tuple in sql?
How many sql databases can you have on one server?
Does sap use sql?
How to avoid duplicate records in a query?
Can you upgrade sql express to full sql?
