What is the different between Stored Procedure and Procedure?

Answer Posted / v.v.s.vamshi krishna

In Procedures we give the functions and parameters to be
used instantly. this scenario goes similar to that of
instant food. This happens when the complexity is less. But
as far as the stored procedures are concerned they provide
much reusability and can complexity can be handled with
much ease.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql constraints?

675


Can you inner join the same table?

616


What is pls integer?

680


what is a view? : Sql dba

714


how to use 'mysql' to run sql statements? : Sql dba

625






Explain the commit statement.

686


Why we use joins in sql?

632


difference between anonymous blocks and sub-programs.

716


What are properties of the transaction?

637


What is a pl/sql block?

680


What is sql basics?

688


Mention what is the function that is used to transfer a pl/sql table log to a database table?

572


Why do we use joins in sql?

605


How many types of cursors supported in pl/sql?

696


What are all different types of collation sensitivity?

622