use of IN/ANY/ALL

Answer Posted / s. syam sundar

IN,ANY,ALL ARE MULTIPLE OPERATORS
THESE ARE USED IN MULTIPLE ROW SUBQUERIES

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does sql profiler work?

570


What is a primary key? Explain

542


What are all the different normalizations?

589


Can we create clustered index without primary key?

523


How to fetch alternate records from a table?

684






How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1710


What is where clause in sql?

535


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

618


What is mutating table error?

664


What is loop in pl sql?

576


how to include numeric values in sql statements? : Sql dba

561


what is subquery? : Sql dba

568


Are there any features that are decommissioned in 11g that are not present in 11g?

1593


What is output spooling in sql*plus?

553


What is rownum?

538