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

Can we save file in database?

901

Explain relational algebra?

926

In which format data is stored in database?

869

What do you understand by intension and extension?

915

How to select a random record from a table?

949

Explain the scenarios or situations under which progress database creates new index entry for a record?

1029

Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?

912

What are the advantages of dbms?

935

What are the 5 databases?

844

What are different relationships existing in database?

995

Why is rdbms important?

868

Is declare cursor executable?

982

What are different partitioning techniques in database?

895

Why would someone use a database?

918

What are the properties of a database?

1017