Can we use distinct and group by together?

0 Answers  

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

Do we need to create index on primary key?

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

What do you mean by stored procedures?

0 Answers  

---

How many sql core licenses do I need?

0 Answers  

---

How do you break a loop in pl sql?

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

how is myisam table stored? : Sql dba

0 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,

---