Answer Posted / raj dhar
Function :- Function always return one value.
Procedure :- Procedure may or may not be return value.
Function :- Function always required " RETURN " key word.
Procedure :- Procedure doesn't require " RETURN" key word.
Function :- Function we use parameter IN.
Procedure :- Procedure we use parameter IN,OUT,INOUT.
etc.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Is oracle a programming language?
How is it different from a normal table?
How to use values from other tables in update statements using oracle?
What is oracle rowcount?
How to select some columns from a table in oracle?
How to view existing locks on the database?
How to define and use table alias names in oracle?
What are the benefits of ordbms?
State and explain about oracle instance?
How do I call oracle stored procedures that take no parameters?
What is the recommended interval at which to run statspack snapshots, and why?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is coalesce function?
How to use like conditions in oracle?
How to get a create statement for an existing table?