Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16874 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
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is the difference between Union and Union all. Which is faster.
How many indexes can be created on a table in sql?
What is substitution variable in pl sql?
What does (*) mean in sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is t sql in sql server?
What is the difference between inner join and natural join?
What is an escape character in sql?
What is a loop in sql?
how does a local variable is defined using t-sql? : Transact sql
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How to get unique records from a table?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
