Answer Posted / manoj

IN- It will return the value based on the parameter;
e.g. select * from emp where salary in ('1000','3000');

ANY-It will compare with any value that has been returned by
the parameter;

select * from emp where salary > any(select salary from emp
where deptno=10)
the salary will be compared with any value that has been
returned by the subquery.

ALL-It will compare with max/min value that has been
returned by the subquery;

select * from emp where salary > all(select salary from emp
where deptno=10)
the salary will be compared with the longest value that has
been returned by the subquery.

What is use of trigger?

875

---

how to check myisam tables for errors? : Sql dba

1261

---

What is a primary key example?

903

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1042

---

What does the argument [or replace] do?

1017

---

How to Execute a Package in PL/SQL.?

1110

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1117

---

Is sql pronounced sequel or sql?

1216

---

What is the use of count (*) in sql?

983

---

How do I use google cloud in sql?

1035

---

Why are indexes and views important to an organization?

900

---

What is procedure explain with example?

896

---

How do I enable sql encryption?

969

---

What is form and report?

929

---

What are the different parts of a package?

1043

---