What is the use of prepared statement?

0 Answers  

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---

Explain the difference between rename and alias?

0 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

What is sql architecture?

0 Answers  

---

---

Can you alter start with clause?

1 Answers   TCS,

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

What is exception? What are the types of exceptions?

0 Answers  

---

Does truncate remove indexes?

0 Answers  

---

what is heap table? : Sql dba

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

what is collation? : Sql dba

0 Answers  

---