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 do you know about Master Data & Transaction Info Package?

0 Answers   ITC Indian Tobacco Company,

---

What is cold backup and hot backup (in case of oracle)?

0 Answers  

---

Which database is faster?

0 Answers  

---

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 Answers  

---

Is database a data structure?

0 Answers  

---

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

0 Answers  

---

What are notification services?

0 Answers  

---

What is a database in a website?

0 Answers  

---

Explain about User_Defined Exceptions?

1 Answers  

---

Explain the Normalized Relations?

0 Answers  

---

What is sql and where is it used?

0 Answers  

---

How to start and stop database control?

0 Answers   MCN Solutions,

---