Answer Posted / rupesh
function must return value whereas procedure may or maynot
return value
Call to Function can be encounter by using select
statement where as procedure can not be call in select
statement
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What are the types of variable use in pl sql?
What is sql scripting?
What has stored procedures in sql?
Explain the update statement in sql
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What are pl/sql packages?
What is the difference between inner join and natural join?
How can you create an empty table from an existing table?
What do you mean by field in sql?
Can pl sql procedure have a return statement?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Explain foreign key in sql?
Why do we use partitions in sql?
What is data type in database?
What normalization means?