Answer / roopa

SELECT
DBMS_METADATA.GET_DDL
('PROCEDURE','<PROCEDURE_NAME>','<SCHEMA_OWNER>')
FROM dual;

Answer / 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

Answer / syed

Go to oracle bin directory and run the export file
it will ask you in the question format

just say 'yes' or 'y' for data with procedure and funcion.

it will include all the procedure and function view and
table.

Differentiate between ‘cluster’ and ‘non-cluster’ index.

0 Answers  

---

How many records can a database hold?

0 Answers  

---

How to Perform Data Cleaning and Preprocessing?

1 Answers  

---

What are vdl and sdl?

0 Answers  

---

What are indexes? What are b-trees?

0 Answers  

---

What are the characteristics of database?

0 Answers  

---

What are the 4 types of database?

0 Answers  

---

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

0 Answers   Wipro,

---

How can I join two tables in database?

0 Answers  

---

Define dbms.

0 Answers  

---

What does <> mean in database?

0 Answers  

---

Explain the terms specialization and generalization.

0 Answers  

---