How do I take a backup of Stored Procedure in Oracle?
- 3 Answers
- 29678 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
What are its two major subsystems of r?
What is the role of database management system?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
Define identity and uniqueidentifier property of column?
Who is the founder of database?
What are the differences between hash join, merge join and nested loops?
How can you get data from a database in an Excel sheet?
What is meant by database system?
Which free database is best?
What do you mean by checkpoints in dbms?
What is the benefit of database?
How to improve query performance using index hunting?
What are the functions of a database?
What is a functional dependency in the dbms?
Explain the different types of database keys?
