Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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?

953


How do databases help businesses?

828


What are the types of database users?

949


Explain the use of assign statement in progress database?

874


How to prevent concurrent access to my data?

985


What are the limitations of rdbms?

909


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping

1868


What is 1nf 2nf 3nf in dbms?

858


Is there a database program for mac?

888


What is variable dbms?

894


What is normal form in dbms?

867


What are the limitations of database?

839


What is erd?

972


What are the advantages of dbms?

892


Explain the syntax of named procedure?

940