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
What are types of joins?
How do you identify a primary key?
Is join same as left join?
How do I find duplicates in two columns?
Can you have a foreign key without a primary key?
How do you remove duplicates without using distinct in sql?
how to drop an existing index in mysql? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is an oracle stored procedure?
How many triggers can be applied on a table?
What is trigger in flip flop?
What is meant by temporal data?
Can we use ddl statements in stored procedure sql server?
What is the current version of sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?