Answer Posted / deepu
functions and procedures are both pl/sql programs.
procedures performs a specific task,it takes parameters and
performs the actions.
functions are same as procedures except they wil return a
value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain index?
Explain compound trigger in oracle?
What is a package in oracle?
What is the database name in oracle?
Why do we need integrity constraints in a database?
How to use an explicit cursor without open statements?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What happens if you set the sga too low in oracle?
What happens to indexes if you drop a table?
How to revoke create session privilege from a user in oracle?
How to return top 5 rows in oracle?
What is define in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
How to use null as conditions in oracle?
