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 is the concept of sub-query in terms of sql?
How do you use a database worksheet?
What is the purpose of a database?
What is the best free database software?
Describe reporting lifecycle?
What is the purpose of database management system?
What is a key in database?
What is normalisation and its type?
What is a checkpoint in dbms?
What do you understand by fragmentation?
Can we store images in database?
Explain the difference between two and three-tier architectures.
What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....
Is declare cursor executable?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping