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

Which is best database?

966

What is a php database?

938

What are the applications of database?

946

What is index hunting?

1250

What entity means?

932

Explain what are super servers?

1200

Define identity and uniqueidentifier property of column?

1118

Define and explain about progress?

990

Explain the terms database and dbms. Also, mention the different types of dbms.

962

What are the components of a database management system?

928

What do you know about Master Data & Transaction Info Package?

1054

What is oracle block? Can two oracle blocks have the same address?

1081

Is there an example how to configure udfaccess setting in firebird.conf?

1004

What is meant by system analysis?

1168

what are the acid properties in dbms?

1072