How many memory layers are in the shared pool?

1 Answers  

---

Is there a combination of "like" and "in" in sql?

0 Answers  

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

How to get a list of all tables in the database?

1 Answers  

---

How oracle handles dead locks?

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  

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

0 Answers  

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

how to tune oracle sql queries pls tell me step by step. urgent pls

1 Answers  

---

What is STATSPACK tool?

3 Answers   Wipro,

---

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

---

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers  

---