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
Explain the components of rdbms?
What is network database?
Define database model.
What are the types of database lock?
How to lock records in a table?
Which database is good for large data?
What is database users in dbms?
What do you understand by the terms entity, entity type, and entity set in dbms?
What are the various types of relationships in database? Define them.
What is data sparsity and how it effect on aggregation?
Can we store images in database?
what are the differences between an exclusive lock and a shared lock?
What is a field in database?
How is view stored in database?
What are the different type of relationships in the dbms?