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

explain advantages of innodb over myisam. : Sql dba

829


What is sqlexception in java?

732


What is the usage of when clause in trigger?

759


How do I install sql?

699


Is delete faster than truncate?

749






What are the types of variable use in pl sql?

742


What is sql trigger example?

751


what is a field in a database ? : Sql dba

755


How does sql profiler work?

753


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

751


Does user triggers have entry for trigger with compilation errors?

792


what is the difference between delete and truncate statement in sql? : Sql dba

761


What is the best free sql database?

769


Can we call stored procedure in function?

706


What is cursor and why it is required?

795