Answer Posted / malkeet kaur
1)functions may or may not have return type but procedure doesn't have return type
2)functions are called from select statement but procedure can not called from select statement
3)fuctions are used when some data is passed to calling environment but procedure is used
when some processing to be done
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we rollback truncate?
What are sql ddl commands?
What are the different schemas objects that can be created using pl/sql?
What is mutating sql table?
How do you use collections in procedure to return the resultset?
Explain constraints in sql?
Could you please provide oca (oracle 10g) dumps for my certification ?
What are all the common sql functions?
What does 0 mean in sql?
Is a secondary key the same as a foreign key?
how to add a new column to an existing table in mysql? : Sql dba
What is a scalar value in sql?
What is left inner join in sql?
What are the advantages of pl sql over sql?
How do I count records in sql?