when we use function instead of procedure? plz tell me the
situation with ex?
- 3 Answers
- 9791 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / adil khan
procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is conditional split?
What is the rdl file?
What are the different types of collation sensitivity?
Can you index views?
What are the types of subquery?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What do you understand by a view?
Explain sql delete command?
What is the process of normalising?
Describe in brief databases and sql server databases architecture.
what information is maintained within the msdb database? : Sql server administration
Define normalisation?
How do you identify a foreign key?
What are the difference between primary keys and foreign keys?
Do you know what are acid properties of transaction?
