what are stored procedures?

Answer Posted / akn

Its nothing but a set of T-SQL statements combined to
perform a single task of several tasks. Its basicaly like a
Macro so when you invoke the Stored Procedure,you actually
run a set of statements

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if you set the sga too low in oracle?

556


Explain what are the uses of rollback segment?

586


What happens if the update subquery returns multiple rows?

612


How to delete a column in an existing table?

595


What is the dynamic sql in oracle?

600






What is an anonymous block?

625


How to execute a stored procedure in oracle?

618


is there a tool to trace queries, like profiler for sql server?

608


What is the difference between truncate & delete command?

617


Explain the difference between a procedure and a function?

561


What is user managed backup in Oracle?

615


Explain a synonym?

606


List the parts of a database trigger.

581


What happens in oracle commit?

572


Can we connect to ORACLE db using Windows Authentication?

722