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.

Explain a database server?

0 Answers  

---

What is the use of INCTYPE option in EXP command ?

1 Answers  

---

Define join types.

0 Answers  

---

write a query to retrieve the last day of next month in oracle.

0 Answers  

---

What is indexing in database with example?

0 Answers  

---

How is the pattern matching done in the sql?

0 Answers  

---

What is use of dbms?

0 Answers  

---

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

0 Answers  

---

Could you give me an example how, where I code checkpoint and restart. I need and example

0 Answers  

---

What are vdl and sdl?

0 Answers  

---

What are stored-procedures? And what are the advantages of using them.

0 Answers  

---

Where is database data stored?

0 Answers  

---