Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

LIKENL

The LIKENL option controls whether the LIKE operator recognizes newline characters between lines of a text expression, when deciding whether a text value is like a text pattern. (In the OLAP DML, the representation of a newline character is "\n".)

The LIKENL option applies to the text expressions on either side of the LIKE operator.

Data type

BOOLEAN

Syntax

LIKENL = {YES|NO}

Arguments

YES

(Default) Specifies that the LIKE operator recognizes newline characters between lines of a text expression.

NO

Specifies that the LIKE operator ignores newline characters between lines of a text expression. Newline characters are ignored in both of the expressions being compared.

Examples

Example 16-1 The Effect of LIKENL

The following statements show the use of the LIKENL option:

  • The statement

    SHOW textvar
    
    

    produces the following output.

    Hello
    world
    
    
  • The statements

    LIKENL = YES
    SHOW textvar LIKE '%low%'
    
    

    produce the following output.

    NO
    
    
  • The statement

    SHOW '       Hello\nworld' LIKE '%\n%'
    
    

    produces the following output.

    YES
    
    
  • The statement

    SHOW 'Hello\nworld' LIKE '%low%'
    
    

    produces the following output.

    NO
    
    
  • The statements

    LIKENL = NO
    SHOW textvar LIKE '%low%'
    
    

    produce the following output.

    YES
    
    
  • The statement

    SHOW 'Hello\nworld' LIKE '%\n%' 
    
    

    produces the following output.

    YES
    
    
  • The statement

    SHOW 'Hello\nworld' LIKE '%low%'
    
    

    produces the following output.

    YES