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)

What is view explain with example?

999

---

Explain the update statement in sql

1044

---

Explain the working of foreign key?

1136

---

what is the difference between delete and truncate commands? : Sql dba

1119

---

How do you take the union of two tables in sql?

1032

---

What is scalar data type in pl sql?

1119

---

What is the difference between inner join and outer join?

1040

---

Can pl sql procedure have a return statement?

1072

---

What operators deal with null?

1154

---

Can we use ddl statements in stored procedure?

1192

---

What operating systems are supported by oracle sql developer?

1015

---

What is an implicit commit?

1103

---

What are the triggers associated with image items?

1089

---

what is the difference between a local and a global temporary table? : Sql dba

1128

---

what is schema? : Sql dba

1113

---