Answer Posted / mythili

Join:
It is the method of joining one or more tables together and
finding a answer.

Sub Query:

It is a method of finding one answer using another query.

Main Difference:

In join both the tables should have a comman column name
but in subquery without having a column name we can execute
the query.

What are transaction isolation levels supported by oracle?

1114

---

please explain.. DB architecture ...

2081

---

What is an oracle data file?

1157

---

Is there a function to split a string in plsql?

1109

---

Can group functions be mixed with non-group selection fields?

1073

---

How to create additional tablespaces for an new database?

1075

---

Is insert autocommit in oracle?

1130

---

In oracle there is column command, how will you explain that?

1135

---

How to insert a new row into a table in oracle?

1215

---

What are the different types of record groups in oracle? Explain each of them

1069

---

Can we store pictures in the database and if so, how it can be done?

1089

---

What are the arithmetic operations?

1146

---

What are the different types of failures that occur in Oracle database?

1116

---

What are the benefits of ordbms?

1136

---

How to rename a column in an existing table?

1081

---