What is the difference between distinct and unique in sql?

0 Answers  

---

What is the need of a partition key?

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

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

0 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

What is Highwatermark?

3 Answers   Thermotech,

---

What are the different tcl commands in sql?

0 Answers  

---

How do I edit a stored procedure?

0 Answers  

---

What is the difference between execution of triggers and stored procedures?

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---