How to create additional tablespaces for an new database?

0 Answers  

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

0 Answers   Oracle,

---

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---

What are the advantages of Views ?

3 Answers  

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

0 Answers  

---

What is Read-Only Transaction ?

3 Answers  

---

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

0 Answers  

---

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

---