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 are named parameters?
How do we get field detail of a table?
How to loop through data rows in the implicit cursor?
What is a cursor in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
State the various uses of dbcc command?
Explain oracle’s server parameter file.
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
State some uses of redo log files?
How to use an explicit cursor without open statements?
What are the different types of database objects?
Can group functions be used in the order by clause in oracle?
How to define an oracle cursor variable?
Can we insert data in view oracle?
What happens if the imported table already exists?
