What are the execution control statements?

0 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

Explain rename?

0 Answers  

---

what is the dual table in oracle?

0 Answers  

---

What is flashback in Oracle?

0 Answers   MCN Solutions,

---

What does a Control file Contain ?

2 Answers  

---

Is rowid unique in oracle?

0 Answers  

---

What is oracle rowcount?

0 Answers  

---

Explain the use of ignore option in imp command.

0 Answers  

---

What is rowid and rownum in oracle?

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,

---

Select the Nth lowest value from a table?

4 Answers  

---