Interested to Buy Any Domain ? << Click Here >> for more details...
How do I take a backup of Stored Procedure in Oracle?
- 3 Answers
- 30417 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
In DBMS, what are the two integrity rules used?
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.....
What is index hunting and how does it help in improving query performance?
What are stored procedures in a database?
Why its better to use files than a DBMS when there are multiple users to access the data
What is the full meaning of dbms?
What is big data in database?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What is distributed queries?
How can I join two tables in database?
What are the differences between hash join, merge join and nested loops?
How do databases help businesses?
Enlist the cursor types.
Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com
Which database is best for storing large data?
