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

Is sql a scripting language?

607


How much ram can sql express use?

605


What is 19 null in sql?

611


How do you remove duplicate records from a table?

592


What does closing a cursor do?

872






How do I write a cron which will run a sql query and mail the results to agroup?

613


What is trigger point?

637


What is primary key and unique key?

647


What is rowid in sql?

589


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2177


what are all types of user defined functions? : Sql dba

642


define data blocks ? : Sql dba

651


Why select is used in sql?

603


what are the advantages of using stored procedures? : Sql dba

704


How many tables can you join in sql?

606