How do I take a backup of Stored Procedure in Oracle?
- 3 Answers
- 29179 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
How to export data from database and import into another?
What information can be stored in a database?
What is unique key in dbms?
Name two utilities that oracle provides, which are use for backup and recovery.
Why is database important?
What is database management used for?
What is database in simple language?
What are stored-procedures? And what are the advantages of using them.
What is netlib for clipper?
What is meant by database system?
Differentiate between nested loop, hash loop and merge join.
What is computer end?
What are rdbms concepts?
Write a query to remove duplicate rows from a table?
What are different types of joins in the sql?
