Answer Posted / amar_kondla

select * from emp----- is a query;


and

co-related query is sub one of sub qury( sub qury
means--whose returning values are filtering the condition
of the main query)
ex; SELECT * FROM EMP E
WHERE E.SAL>( SELECT AVG(SAL) FROM EMP F
WHERE E.DEPTNO= F.DEPTNO);


SO HERE WE R FINDING THE EMPLOYEE WHO HAS GETTING MORE THAN
AVG(SAL) OF RESPECTING DEPTNO.

AND CO RELATED SUB QUERY ALWAYS USE ALIAS NAME FOR TABLE, IT
SIMILAR LIKE JAIN(SELF JOIN)

How many triggers can be applied on a table?

983

---

Is oracle and sql same?

1073

---

What is trigger types of trigger?

1138

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1094

---

Is sql considered coding?

1085

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1059

---

How do I edit a stored procedure?

1044

---

What are the ddl commands?

1051

---

Which is better join or inner query?

1119

---

Explain raise_application_error.

1141

---

Define implicit and explicit cursors.

1203

---

tell us something about heap tables. : Sql dba

1134

---

List the different type of joins?

1111

---

What is sql dialect?

1170

---

Explain the uses of control file.

1094

---