What is primary key and foreign key?

0 Answers  

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

---

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

---

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 the difference between stored procedure and view?

0 Answers  

---

---

Can a select statement fire a trigger?

0 Answers  

---

What is the usage of distinct keyword?

0 Answers  

---

What are analytical functions in sql?

0 Answers  

---

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

---

What is a heap in sql?

0 Answers  

---

What is mutating table?

11 Answers   Saama Tech,

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---