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

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

0 Answers  

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

What are keys in sql?

0 Answers  

What is difference sql and mysql?

0 Answers  

How to use distinct and count in sql query? Explain

0 Answers  




types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

How many rows can sqlite handle?

0 Answers  

what is an index? : Sql dba

0 Answers  

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

How do you exit in sql?

0 Answers  

What is a native sql query?

0 Answers  

What is use of trigger?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories