Answer Posted / chaudhry

Schema objects are the logical structures that directly
refer to the database's data. Schema objects include tables,
views,
sequences, synonyms, indexes, clusters, database triggers,
procedures, functions packages and database links.

Why is oracle so popular?

1051

---

How do I spool to a csv formatted file using sqlplus?

1083

---

How many file formats are supported to export data?

1263

---

What is the difference between I and G in Oracle?

1147

---

How to assign values to data fields in record variables?

1077

---

How to add another datafile to a tablespace?

1087

---

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?

1436

---

Can we save images in a database and if yes, how?

1108

---

How to insert a record into a table?

1118

---

Explain a segment?

1127

---

How to work with data objects interactively?

1041

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2393

---

what is meant by magic query

2230

---

What privilege is needed for a user to create indexes in oracle?

1078

---

List out the types of joins.

1236

---