How do I take a backup of Stored Procedure in Oracle?
- 3 Answers
- 29613 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
Is sql a database?
What do you understand by e-r model?
Why do we need foreign key?
Is there a database program for mac?
What do you understand by data redundancy?
What is the purpose of reports in a database?
What is the normal procedure followed by a java client to access the db?
What are the integrity rules in dbms?
What is 2nf and 3nf?
What is information schema in database?
What is database connection pool size?
What is sorting in dbms?
Explain fully functional dependency?
Which is better saving files in database or in file system?
Mention some advantages of using dbms.
