Answer / Vikram Singh Vimal

To trace SQL Profiler, you first need to create a new trace by defining events of interest and setting the properties (such as file location). Then, start the trace, perform actions in your database, stop the trace, and analyze the generated trace file.

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

5 Answers  

---

What is the clause we need to add in function body to return variable?

1 Answers  

---

how to create a new view in mysql? : Sql dba

1 Answers  

---

what is a table in a database ? : Sql dba

1 Answers  

---

What are the uses of merge?

1 Answers  

---

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

Explain aggregate functions are available there in sql?

1 Answers  

---

How do I order columns in sql?

1 Answers  

---

What are some predefined exceptions in pl/sql?

1 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

How many developers work on postgresql?

1 Answers  

---

i need department wise top 2 employees salary.which logic i will use

17 Answers  

---