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 the difference between a delete command and truncate command?

982

What is the advantage of the database management approach

1060

Explain the hierarchical database?

1007

What is bcnf?

1032

Why is rdbms important?

886

What are the different levels of abstraction in the dbms?

902

What is the purpose of database management system?

1051

Discuss some of the techniques that can be used to tune operational performance.

961

What do you understand by intension and extension?

923

What is the best free database software?

878

Which software is best for database?

890

for what purpose we use MDM(master data management)tell me plz.

4182

How do you create a report in a database?

870

What are the different types of database?

1017

How to unzip a file in ssis?

1072