What is the different between Stored Procedure and Procedure?

Answer Posted / rasmita basantia

if we are writing a procedure with create or replace
syntax ,then its a procedure.if its compiled and stored in
the data base then its called stored procedure.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define tables and fields in a database

829


Does mysql_real_escape_string prevent sql injection?

688


What is data control language?

733


What is sqlite used for?

697


How do I find duplicates in sql?

689






What is trigger in sql and its types?

754


What is dml statement?

696


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

764


What is a unique key?

773


what is normalization? : Sql dba

737


what is the bond code in materialized view?

2678


I need a function for a train ticket reservation please answer it thanks in advance

758


What is sql character function?

709


What is the left table in sql?

697


Explain the purpose of %type and %rowtype data types with the example?

740