Interested to Buy Any Domain ? << Click Here >> for more details...
How do I take a backup of Stored Procedure in Oracle?
- 3 Answers
- 30289 Views
- I also Faced
- E-Mail Answers
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 is the difference between horizontal and vertical partitioning?
Why are databases so important?
How do convert or display the date or time as string?
What is difference between database and server?
What do you understand by data independence? What are its two types?
Explain openquery function and openrowset function?
Why normalisation is required?
How to select a random record from a table?
How to tell firebird to only accept conections from xyz host or network?
What do you mean by query evaluation engine?
What do you understand by unique key?
Explain atomicity and aggregation?
What is e-r model in the dbms?
What are the characteristics of data in the database?
What is vacuum in database?
