Answer Posted / subbareddy k

A table can have 1000 columns and 255 rows upto Oracle 8i.I
don't know in Oracle 9i.Please give proper answer

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

2675

---

Explain enable novalidate constraint.

1132

---

How to define a variable of a specific record type?

1116

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2263

---

Write a syntax for update query in oracle?

1074

---

What is oracle in java?

1017

---

What is the sid in oracle?

1032

---

How to count duplicated values in a column in oracle?

1105

---

How to write numeric literals in oracle?

1236

---

What is tns entry?

1236

---

Explain coalesce function?

1250

---

What is the Tune Query

2346

---

why dont we assign not null constraint as table level constraint.

2797

---

How to estimate disk space needed for an export job?

1105

---

How to recover a dropped table in oracle?

1094

---