Is sql free?

0 Answers  

---

How do I tune a sql query?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

What do you know by pl/sql cursors?

0 Answers  

---

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

Can we insert data into materialized view?

0 Answers  

---

What is the difference between join and natural join?

0 Answers  

---

What is procedure explain with example?

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  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---