What are different joins used in sql?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

Is it possible to pass parameters to triggers?

0 Answers  

---

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

0 Answers  

---

What is foreign key in sql with example?

0 Answers  

---

Why is sharding used?

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

What are the ways on commenting in a pl/sql code?

0 Answers  

---

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

---

How do I install microsoft sql?

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---