what diffrence between function and procedure?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / manu sankar
Functions can be called inside a sql but procedures cannot
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pr@$@d
Hi Raj ,
Nice answer,
We can use OUT,INOUT also in function but it is not
suggested by Oracle.
Thanks,
-Pr@$@d.
prasadreddi@ymail.com
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
how to get count of tables in particular database in Oracle?
what are the default admin accounts in Oracle 10g ?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
what are the diffeenes between oracle 9i,oracle 10g
can we pass two out parameters at a time in function?please answer to my question
What is trigger associated with the timer ?
How to commit the current transaction in oracle?
Can a formula column referred to columns in higher group ?
List the various oracle database objects?
What is index in Oracle?