How do I take a backup of Stored Procedure in Oracle?

Answer Posted / roopa

SELECT
DBMS_METADATA.GET_DDL
('PROCEDURE','<PROCEDURE_NAME>','<SCHEMA_OWNER>')
FROM dual;

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the two types of database?

688


Why do we need database?

692


Which is the best database?

704


How does a database partition work?

682


What do you understand by intension and extension?

681


What is the most used database?

746


How to improve query performance using index hunting?

877


Why is group-clause used?

739


Explain why an information gap exists in most organizations.

714


What is the difference between shrink database and shrink file?

691


What are procedures in dbms?

670


What is database url?

704


Briefly describe the three types of sql commands.

707


Define sub-query.

729


What is a database in business?

736