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

Explain what does a control file contain?

610


Explain the use of file option in exp command.

601


Difference between inner join vs where ?

611


How index is implemented in oracle database?

596


How to convert raw data type into text in oracle? Explain

603






How to join two tables in a single query using oracle?

566


How to convert characters to dates in oracle?

561


How to run create database statement again?

622


How to run create database statement?

579


Explain how you would restore a database using RMAN to Point in Time?

1638


State the difference between a primary key and foreign key?

518


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1661


What is hot backup and logical backup?

610


What is a private synonym?

1086


how to handle exceptions in post production

950