what are properties of a transaction? : Sql dba

0 Answers  

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

Why truncate is faster than delete?

0 Answers  

---

Can there be 2 primary keys in a table?

0 Answers  

---

Is mariadb a nosql database?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

What is character functions?

0 Answers  

---

What is user define exception and example

1 Answers   HP, KP,

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

Is nosql faster than sql?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What are the uses of merge?

0 Answers  

---