I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

How many memory layers are in the shared pool?

3 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---