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
How do I partition a table in sql?
How many sql core licenses do I need?
What are the operators used in select statements?
How can you fetch common records from two tables?
Does inner join return duplicate rows?
What is over () in sql?
What are literals in sql server?
Is there any restriction on the use of union in embedded sql?
What are the disadvantages of file system?
What are the two different parts of the pl/sql packages?
What is the maximum number of triggers, you can apply on a single table?
How many indexes can be created on a table in sql?
What is the difference between a primary key and a unique key?
What does rownum mean in sql?
What is the difference between partition and index?