Answer / Ajay Prakash Vishwakarma

To view a SQL trace file, you can use tools like SQL Server Profiler or third-party applications that support reading SQL trace files (.trc extension). These tools allow you to analyze the captured data and identify performance issues.

What are the Restrictions on Cursor Variables?

2 Answers  

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

1 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

What are instead of triggers?

1 Answers  

---

What are stuff and replace function?

1 Answers  

---

what are the properties and different types of sub-queries? : Sql dba

1 Answers  

---

What is record type in pl sql?

1 Answers  

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

what is auto increment? : Sql dba

1 Answers  

---