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 is the difference between odbc and drs stage?

864


What are the repository tables in datastage?

1076


Differentiate between operational datastage (ods) and data warehouse?

936


how do u catch bad rows from OCI stage? And what CLI stands for?

2579


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

1693


Define orabulk and bcp stages?

919


What are the main differences you have observed between 7.x and 8.x version of datastage?

864


what is the use of materialized view?

1226


Nls stands for what in datastage?

972


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1843


Explain usage analysis in datastage?

903


What are the difference types of stages?

851


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1282


Does datastage support slowly changing dimensions ?

872


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1992