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
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How to set up sql*plus output format in oracle?
What are local and global variables and their differences?
What are all the different normalizations?
What are the advantages of sql?
What is the current version of postgresql?
how to drop an existing index in mysql? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
Explain lock escalation? : Transact sql
how would you enter characters as hex numbers? : Sql dba
Can function return multiple values in sql?
What are the subsets of sql?
Who is the owner of mysql database?
what does the t-sql command ident_incr does? : Transact sql
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql