what are stored procedures?

Answer Posted / sapna kalburgi

Stored procedure is a set of SQL statements used to perform
some particular task.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use subqueries with the in operator using oracle?

854


What is the difference between hot backup and cold backup in oracle?

782


Why do you use stored procedures and state some of its disadvantages?

812


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1793


State and explain the different types of data models?

745


How to define an anonymous procedure with variables?

789


How to assign values to data fields in record variables?

807


How is it different from a normal table?

811


How to sort output in descending order in oracle?

852


what is normalisation?what are its uses?

1979


Explain index?

1023


How to start an oracle instance?

802


What is raw datatype?

869


Why do we need integrity constraints in a database?

793


What is the difference between translate and replace in oracle?

937