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 parameters are optional in init.ora parameter file?

2212

What are databases what are the uses of databases?

921

What do you mean by fill factor concept with respect to indexes?

960

How many records can a database hold?

946

What is db context?

915

Why dbms is used?

944

What are the types of model?

881

What are the main features of a database?

1033

What are the features of dbms?

946

Define ddl interpreter.

1135

Which free database is best?

856

What is the difference between horizontal and vertical partitioning?

994

What is dbms and types of dbms?

1086

Is file system a database?

929

Explain the terms specialization and generalization.

950