Answer Posted / manish

select * from emp; --->> query

select * from emp where sal=(select max(sal) from emp);
--> here a sub query is also there

select * from emp outer where sal= ( select avg(sal) from
emp e where dept.e=dept.outer) --> corelated query

What is type and rowtype in pl sql?

978

---

what is heap table? : Sql dba

1060

---

what are the differences between char and varchar? : Sql dba

1019

---

What is sorting in sql?

904

---

what is dbms? : Sql dba

942

---

what are local and global variables and their differences? : Sql dba

1026

---

How do sql databases work?

962

---

Explain the uses of database trigger.

1060

---

Is join and inner join the same?

956

---

Can we update views in sql?

906

---

How does a covering index work?

913

---

Can two tables have same primary key?

924

---

What is implicit cursor in pl sql?

1040

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3528

---

Can you load data into multiple tables at once? : aql loader

1033

---