Answer Posted / krishna

oracle 10g has many features compare to 9i like
asm,swr,addm,flaskback recovery,data pump..
generating snap shot is much more flxible in 10 g compare to 9i

What is proxy method?

960

---

does the query needs a hint to access a materialized view?

1844

---

What is Virtual Private Database in Oracle?

1064

---

How to filter out duplications in the returning rows using oracle?

1006

---

What is data block in Oracle?

1089

---

Explain the features of oracle?

1021

---

What is a directory object?

1071

---

How do I escape a reserved word in oracle?

1185

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2604

---

How many types of synonyms in Oracle?

1104

---

How to find the duplicate rows count from employees table in oracle?

1067

---

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.

2171

---

How to define a data field as not null?

1092

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

987

---

What are the different oracle database objects?

1076

---