Answer Posted / ashi

Sub query: The sub query has more than one select
statement,the inner query which executes first and then it
will be the value of the 2nd query.
EX:
select ename from emp where sal>(select avg(sal) from emp);

Joins:
When the data from more than one table in the database,then
a join condition used.Rows in the one table can be joined to
rows in the other table according ro the common values
existing in corresponding columns
EX:
select dname,ename from emp,dept where emp.deptid=dept.deptid;

What is the maximum limit on the number of columns in a table?

1077

---

How to run the anonymous block again?

1124

---

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.

2179

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2318

---

What is the order of defining local variables and sub procedures/functions?

1055

---

What are the system predefined user roles?

1037

---

Can we store images in oracle database?

1001

---

What is a cursor in oracle?

1170

---

How many categories of data types in oracle?

1025

---

What are the oracle differences between nvl and coalesce

1145

---

What is a sub query? What are its various types?

1166

---

What is primefaces used for?

1045

---

What are the extensions used by oracle reports?

1033

---

What is data block in Oracle?

1112

---

What are the different types of modules in oracle forms?

999

---