if we are writing a procedure with create or replace syntax ,then its a p

What is the different between Stored Procedure and Procedure?

Question Posted / rasmita basantia

7 Answers
14121 Views
Informatica, MIS, I also Faced
E-Mail Answers

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

Are stored procedures compiled?

873

How to select unique records from a table?

1002

what is bdb (berkeleydb)? : Sql dba

976

what is oltp (online transaction processing)? : Sql dba

1016

What is use of package in pl sql?

952

What is procedure function?

985

can a stored procedure call itself or recursive stored procedure? : Sql dba

960

What is the usage of when clause in trigger?

992

What is localdb mssqllocaldb?

1017

Why stored procedure is faster than query?

951

What is the use of count (*) in sql?

983

Does asenumerable execute the query?

986

What is the difference between a primary key and a unique key?

1001

What is sql mysql pl sql oracle?

1028

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

915