difference between function and procedure...

Answer Posted / rajesh.dwh

Function must returns value, but Procedure may or may not
return value.
Function can be use with select statement where Procedure
can't be used with select statement regarding ORACLE SELECT
statement.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2518


What is active and passive stage?

1150


What is the difference between the local container and shared container?

862


How many areas for files does datastage have?

870


Explain the situation where you have applied SCD in your project?

1790


What is aggtorec restructure operator?

1101


Difference between in process and inter process?

929


What are system variables and sequencers in datastage

841


Nls stands for what in datastage?

958


How do you register plug-ins?

774


What is the roundrobin collector?

854


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1678


How do you schedule or monitoring the job?

879


Triggers,VIEW,Procedures

996


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1890