Oracle wildcards and operators

Oracle wildcards and operators used for where comparison include: equal to:, & lt;, & lt;, & gt;, & gt;, and & lt; & gt; including: in, notinexists, notexists range:... and, notbetween .... and Matching Test: like, notlikeNull test... oracle wildcards and operators used for where comparison are: equal to: =, <, <=,>, >=, <> include: in, not in exists, not exists range: between... and, not .... and Matching Test: like, not like Null test: is null, is not null Boolean link: and, or, not www.2cto.com wildcard: In the where clause, wildcard characters can be used with the like condition. In Oracle: % (percent): represents any number of characters, or may have no characters at all. _ (Underline): indicates the exact unknown character.? (Question mark): used to indicate the exact unknown character. # (Well number): used to indicate the exact Arabic number, ranging from 0 to 9. [A-d] (square brackets): used to indicate the character range from a to d. Single quotes ('): in Oracle, only single quotes should be used to enclose text, characters, and dates. No quotation marks (including single double quotes) can be used to enclose numbers. Double quotation marks ("): in Oracle, single double quotation marks have different meanings. Double quotation marks are used to enclose column aliases that contain specific characters or spaces. Double quotation marks are also used to place text in the date format. Marker ('): in Oracle, the marker can also be written as two adjacent single quotes. To search for all vendor names with marker in the Supplier name, you can write the code as follows: select * from l_suppliers where supplier_name like '% ''%' & Symbol: in Oracle, & symbol is often used to indicate a variable. For example, & fox is a variable, a little different & fox. Every time & fox appears in an Oracle script, you are required to provide a value for it. To use & fox, you only need to provide the variable value when & fox appears for the first time. If you want to use & as a common symbol, you should disable this feature. To disable this feature, run the following command: set define off, which is a SQLplus command, not an SQL command. SQLplus sets the environment in which SQL runs in Oracle. Double vertical bars (|): Oracle uses double vertical bars to represent string connection functions. Asterisk (*): select * indicates that all columns are selected, and count (*) indicates that all rows are calculated. When a wildcard is used, it indicates 0 or any number of characters. Forward slash (/): Used to terminate an SQL statement in Oracle. More accurately, it indicates "running SQL code in the buffer zone ". A forward slash is also used as a separator. Not equal to: there are multiple expressions :! =, ^ =, <>, Not xxx = yyy, not (xxx = yyy)