Sunday, August 21, 2016

Oracle SQL - IN Operator

IN

Use in operator to check if the value exists in the set  of values.
The set of values can be in any random order.

IN operator can be used with any data type. If character or data type values are used in the list, enclose them with single quotes  ' ' .

Examples:























list of values can be from a select query.




























If Values in the IN list are character type, enclose them in single quotes.


Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts