When do we use group by clause in a sql query?

0 Answers  

---

what is foreign key?

5 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

How to drop an index?

0 Answers  

---

what is null value?

9 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

0 Answers  

---

How to write text literals in oracle?

0 Answers  

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

How to define an oracle sub procedure?

0 Answers  

---

Describe the types of sub query?

0 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---