what are stored procedures?

Answer Posted / suguna

It is nothing but data base object it is stored in data
base whenever we required we will specify the procedure
name & execute it

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we force the database to use the user specified rollback segment?

850


How view is different from a table?

820


What is partitioned table in Oracle?

865


Explain what are the characteristics of data files?

842


How do I recompile a procedure in oracle?

749


How to use select statement to count the number of rows in oracle?

800


What is clustered table in Oracle?

875


What happens to the current transaction if the session is ended?

839


Can we insert data in view oracle?

770


What privilege is needed for a user to create tables in oracle?

770


Explain the blob datatype?

829


What are the predefined tablespaces in a database?

795


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1682


How to turn on or off recycle bin for the session?

843


How to do paging with oracle?

788