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

How to know the Architecture of the Database

889


What is 3nf in dbms?

704


How to configure events with firewall?

767


What database does facebook use?

739


How do you delete a table from database?

721


Explain the terms ‘attribute’ and ‘relations’

913


how to retrive a data From database into the grid view..?

711


Explain the concept of acid properties in dbms?

863


Explain issues for database performance.

738


What is the best free database?

722


What is bcnf in the dbms?

703


What is limit in dbms?

733


What is data modelling techniques?

625


Segregate database technology's development.

1295


Explain some of the uses of openedge architect features useful for a developer?

725