Answer Posted / 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 about cursors?

1091

---

How can I create database in excel?

930

---

What is the meaning of flat file database?

1004

---

What exactly is a database?

875

---

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

2108

---

What is data sublanguage?

1038

---

What does rdbms stand for?

1076

---

Discuss transparent DBMS?

1201

---

What is a sequence in a database?

1007

---

What is the normal procedure followed by a java client to access the db?

825

---

Compare a hierarchical and network database model?

990

---

What is the difference between case version and decode version?

1026

---

What are the various types of relationships in database? Define them.

895

---

what do u mean by implementation?

2165

---

Explain about the properties of cursors?

1024

---