Answer / sudipta santra

Inline query :
select * from emp where empno=(select max(empno) from emp);

Co-Related sub query:

Select * from emp where dob> (select distinct dob where
deptno= 10);

Note: In the Inline subquery , The main query depends upon
the outcome value of the inline sub query which is in-lined
but in case of co-related sub query the main query and sub
query both run simultaneously then the check occurs.

What is sonicmq?

0 Answers  

---

What do you understand by fragmentation?

0 Answers  

---

How do you invoke datastage using unix?

3 Answers  

---

For each user who needs access, the DBA creates an account in which database?

0 Answers  

---

What do you understand by b-trees?

0 Answers  

---

dear sir please provide what question will be asked in bank it officer interview

0 Answers  

---

Is it good to save image in database?

0 Answers  

---

what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?

0 Answers  

---

What is compound key?

0 Answers  

---

What is the purpose of using a model?

0 Answers  

---

What is progress open edge?

0 Answers  

---

What are the basic elements of Base configuration of an oracle Database ?

1 Answers  

---