Answer Posted / kiran

data dictionary is what holds the information of all the
database tables , so one can easily get the statistics or
the characteristics of any existing objects in the database
by using appropriate queries

How a tablespace is related to data files?

1109

---

What is the sql query to concatenate column values from multiple rows in oracle?

1056

---

What do you mean by a deadlock?

1065

---

How much memory your 10g xe server is using?

1103

---

How to assign values to variables?

1101

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

---

How to handle a single quote in oracle sql?

1052

---

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

1078

---

How to define an anonymous procedure with variables?

1158

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1032

---

What is control file used for?

1207

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1382

---

How to convert characters to dates in oracle?

1098

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

---

What is data block in Oracle?

1116

---