Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

How does pl sql work?

0 Answers  

---

Can we insert data in view?

0 Answers  

---

Explain what is a database?

0 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

---

What are the possible values for the boolean data field?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

Why is sql*loader direct path so fast?

0 Answers  

---

What is a file delimiter?

0 Answers  

---

Write a sql query to find the names of employees that begin with ‘a’?

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,

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---