SELECT DBMS_METADATA.GET_DDL ('PROCEDURE','<PROCEDURE

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

Question Posted / roopa

Answer Posted / roopa

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

Is This Answer Correct ?

15 Yes

0 No

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