Answer / devraj

Select ca.name, ora.ordid, Ora.Orderdate From customer ca,
ord Ora Where Ora.Custid = ca.custid;

Answer / anjum

select c.name,o.ordid,o.orddate from customer c join oreder o
using(custid);

What is system tablespace?

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,

---

Is truncate autocommit in oracle?

0 Answers  

---

What is program global area (pga) in oracle?

0 Answers  

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---

---

What is a named program unit?

0 Answers  

---

What is a dead lock in oracle?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

What is a Schema ?

6 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

What are advantages fo Stored Procedures?

1 Answers  

---

what is a view?

7 Answers  

---