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
How to display the records between two range in Oracle SQL Plus?
What are sql built in functions?
Is sql scripting language?
what are null values? : Sql dba
Does pl/sql support create command?
Is left join faster than inner join?
What are the commands used in sql?
Can we use pl sql in mysql?
Why select is used in sql?
What is sql and explain its components?
what are the different functions in sorting an array? : Sql dba
Name three sql operations that perform a sort.
How do I run sql profiler?
Show the cursor attributes of pl/sql.
What is loop in pl sql?