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

What is dml and ddl?

513


what is schema? : Sql dba

554


What is normalisation in sql?

539


What is the difference between local variables and global variables?

598


What is the maximum number of triggers, you can apply on a single table?

536






Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

486


What are the differences between in and exists clause?

557


What is difference between mysql and postgresql?

505


What is the source code of a program?

500


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

490


Which join is like inner join?

555


Why is there a need for sqlcode and sqlerrm variables?

577


Does sql backup shrink transaction log?

543


What is normalization in sql?

518


what are the advantages and disadvantages of cascading style sheets? : Sql dba

543