How do I take a backup of Stored Procedure in Oracle?
Answer Posted / roopa
SELECT
DBMS_METADATA.GET_DDL
('PROCEDURE','<PROCEDURE_NAME>','<SCHEMA_OWNER>')
FROM dual;
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What are the two types of database?
Why do we need database?
Which is the best database?
How does a database partition work?
What do you understand by intension and extension?
What is the most used database?
How to improve query performance using index hunting?
Why is group-clause used?
Explain why an information gap exists in most organizations.
What is the difference between shrink database and shrink file?
What are procedures in dbms?
What is database url?
Briefly describe the three types of sql commands.
Define sub-query.
What is a database in business?