Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

How to test for null values?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

---

Can a select statement fire a trigger?

0 Answers  

---

Does sql support programming?

0 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---

What are the types of queries in sql?

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

Is record in pl sql?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---