What is the difference between procedure and stored procedur?

Answer Posted / raja

Hi,

I think, Diff b/w Application Procedure and Stored
Procedure.
Application Procedure developed in Oracle Developer tools
such as Forms, etc and stored in the same application.
But Stored procedure stored in oracle server.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what transformation and how many are there in informatica?

587


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1958


What is a router transformation?

727


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1650


What you know about transaction control transformation?

645






As union transformation gives UNION ALL output, how you will get the UNION output?

730


What is meant by incremental aggregation?

668


What is a surrogate key?

668


Briefly define reusable transformation?

724


what is the size of your data warehousing?

1761


write a query to retrieve the latest records from the table sorted by version(scd)

721


Where are the source flat files kept before running the session?

721


What do you understand by SOA of Informatica?

668


Enlist the differences between database and data warehouse.

638


Define filter transformation?

718