SELECT DBMS_METADATA.GET_DDL('PROCEDURE',a.object

How do I take a backup of Stored Procedure in Oracle?

Question Posted / awa

3 Answers
30595 Views
I also Faced
E-Mail Answers

Answer Posted / awa

SELECT
DBMS_METADATA.GET_DDL('PROCEDURE',a.object_name,a.owner)
FROM = dba_objects a WHERE OWNER =3D'SCHEMA_OWNER' AND
object_TYPE =3D'PROCEDURE' ORDER BY owner

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1843

What is alternate key?

995

What does a database contain?

930

Explain what are super servers?

1200

What are the 4 types of database?

1067

What is dbms and its functions?

1056

Why are databases so important?

1000

What do you mean by conflict serializability in dbms?

969

Is database a data structure?

924

Define ddl interpreter.

1186

How can I join two tables in database?

1110

what is the difference between filters and conditions?

2506

What are cursors give different types of cursors?

1003

What are the different types of database keys?

1111

Explain armstrong rules? How they are complete and/or sound?

952