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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are sql stored procedures used?

619


What is cross join example?

556


How many commands are in sql?

529


Explain isolation levels. : Transact sql

579


Can two tables have same primary key?

532






Are there any features that are decommissioned in 11g that are not present in 11g?

1596


What is dml statement?

519


What is the difference between truncate and drop statements?

581


How do you rename a table in sql?

534


What is a recursive stored procedure?

621


What do you understand by pl/sql records?

535


How do I view a table in sql?

547


What are the types of dbms?

547


What is offset and limit in sql?

555


how to extract a unit value from a date and time? : Sql dba

558