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

Explain the components of rdbms?

584


What is network database?

526


Define database model.

622


What are the types of database lock?

568


How to lock records in a table?

534






Which database is good for large data?

495


What is database users in dbms?

511


What do you understand by the terms entity, entity type, and entity set in dbms?

526


What are the various types of relationships in database? Define them.

478


What is data sparsity and how it effect on aggregation?

508


Can we store images in database?

480


what are the differences between an exclusive lock and a shared lock?

497


What is a field in database?

514


How is view stored in database?

547


What are the different type of relationships in the dbms?

505