Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the basic difference between a sql and stored
procedure ?

Question Posted / shriram

Answers were Sorted based on User's Feedback



What is the basic difference between a sql and stored procedure ?..

Answer / karthik murugan

sql is not a named block, it can be stored as sql file outside the database, when stored procedures are named block can be stored inside the database.

Is This Answer Correct ?    7 Yes 0 No

What is the basic difference between a sql and stored procedure ?..

Answer / thanjairajan@gmail.com

SQL is a Language. Stored procedure is transact SQL statement.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

How do I start sql profiler?

0 Answers  

write a query to delete similar records in same table

13 Answers   TCS,

Name the different types of indexes in sql and define them.

0 Answers  

What is rank () in sql?

0 Answers  




What is the difference between sql, mysql and sql server?

0 Answers  

Why function is used in sql?

0 Answers  

Is join an inner join?

0 Answers  

Which is better stored procedure or query?

0 Answers  

Explain the structure of pl/sql in brief.

0 Answers  

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

Why stored procedure is faster than query?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories