How many types of synonyms in Oracle?

0 Answers   MCN Solutions,

---

How do I know if oracle client is installed on windows?

0 Answers  

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---

Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

---

Point out the difference between user tables and data dictionary?

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

How can we create the complete backup of data in the oracle.

0 Answers   IPEC, Satyam, SunTec,

---

Is there any function in oracle similar like group_concat of mysql?

0 Answers  

---

What is save point in oracle database?

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  

---

What is BBED in Oracle?

0 Answers   MCN Solutions,

---