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

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

Can we change the table name in sql?

0 Answers  

What is the basic form of sql query?

0 Answers  

what is a trigger? : Sql dba

0 Answers  

What is the use of pl/sql table?

0 Answers  




how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,

What is magic table?

6 Answers  

what is dbms? : Sql dba

0 Answers  

What is the left table in sql?

0 Answers  

What is an example of translating a date into julian format?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories