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

What is a key in database?

838

What do you understand by join?

976

What's the difference between 'union' and 'union all' ?

944

Explain the term entity in dbms?

855

What is rdbms and its features?

915

Why do we need database normalization?

939

What are the ways to controlling cursor behavior?

892

What is dba in dbms?

969

What is a concurrency problem in dbms?

925

How big is google's database?

853

What is an image database?

873

What is the purpose of queries in a database?

1001

What is the best free database software?

818

What is normalization? What are different type of normalization?

880

What do database languages do?

890