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
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
How do databases help businesses?
What are the types of database users?
Explain the use of assign statement in progress database?
How to prevent concurrent access to my data?
What are the limitations of rdbms?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
What is 1nf 2nf 3nf in dbms?
Is there a database program for mac?
What is variable dbms?
What is normal form in dbms?
What are the limitations of database?
What is erd?
What are the advantages of dbms?
Explain the syntax of named procedure?