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
What is a dead lock in oracle?
Explain oracle left join with an example?
How to assign data of the deleted row to variables?
What are the advantages of oracle 12c?
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)
How to drop an index?
What is SQL Tuning Advisor in Oracle?
Explain mutating triggers.
How to declare a local variable?
Does oracle database need java?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Can you drop an index associated with a unique or primary key constraint?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Is oracle a language?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?