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 can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---