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

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1647


Could anyone give brief explanation bout datastage admin

1982


how to add a new records into source?

1539


what is the custome stage in datastage? how can we impliment that one? plz tell me

1919


What is the purpose of pivot stage?

620






On which interface you will be working as a developer?

645


What are stage variables, derivations and constants?

687


explain about citrix scheduling tool in datastage

1822


How to Remove Duplicate using SQL?

858


Describe link sort?

664


Why do we use exception activity in Datastage?

737


What is size of a transaction and an array means in a datastage?

753


What is the use of datastage director?

597


Can you explain players in datastage?

717


How can we improve the performance in datastage?

663