How do I take a backup of Stored Procedure in Oracle?
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
what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?
Explain what are service-specific middleware?
What is dbms with example?
What do you mean by e-r model?
What is acid property in dbms?
how to retrive a data From database into the grid view..?
Define a relation schema and a relation.
What is 2nf and 3nf?
How to pump the data from one database to another?
What are the different types of modeling?
What is the difference between internal and external schema?
Why rdbms is not suitable for big data?
How do you create a database?
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
Why is data modelling important?