Answer / sudipta santra

ADDING THE CYCLE KEYWORD.

ALTER SEQUENCE SQ1 CYCLE;

What is the exact use of Collections?

0 Answers  

---

8. Display the client name and order date for all orders using the natural join keywords.

1 Answers   Wipro,

---

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,

---

What is oracle in java?

0 Answers  

---

What is a materialised view?

5 Answers  

---

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

what is reindexing?

0 Answers   Tata Technologies,

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

How to put more than 1000 values into an oracle in clause?

0 Answers  

---

What is oracle rowcount?

0 Answers  

---

how do u know the total no of rows in a table?

6 Answers  

---

how to retrieve 1st and last row of table without using group functions??

6 Answers  

---