Interested to Buy Any Domain ? << Click Here >> for more details...
what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?
- 3 Answers
- 8123 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / dinakar
Though Procedure returns a value through OUT parameter, it
cannot be used in SELECCT statement. Whereas a function can
be called in SELECT statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain exception handling in pl/sql?
Why query optimization is needed?
What does fetching a cursor do?
How much does a sql dba make? : SQL DBA
What does (+) mean in sql joins?
What is case function?
Do foreign keys improve performance?
How do you delete data from a table?
What is a clob in sql?
What is union and union all keyword in sql?
How do you update f as m and m as f from the below table testtable?
Is subquery faster than join?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Is there a 64 bit version of ssms?
What is the difference between a primary key and a unique key?
