How can I introduce multiple conditions in like operator?

0 Answers  

---

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 Answers  

---

What are various joins used while writing SUBQUERIES?

2 Answers  

---

how to find the n'th highest salary from emp ?

10 Answers  

---

What is a sub query? What are its various types?

0 Answers  

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

please explain.. DB architecture ...

0 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,

---

create one table to capture an employee details with a primary key.

1 Answers   CTS,

---

What happens to the data files if a tablespace is dropped?

0 Answers  

---

What do you understand by a database object? Can you list a few of them?

0 Answers  

---

State any two functions of oracle?

0 Answers   Aricent,

---