Pattern Matching

LIKE :- The LIKE predicate allows for a comparison of one string value with another string value, which is not identical. This is achieved by using wildcard characters. Two wild card characters are give bellow.
1)         %     à   percent sign matches any string.
2)         _       à    Underscore sign matches any single character.

Ex:-     1)    select * from vision where na like ‘r%’;
2)     select * from vision where na like ‘_a%’;

For
Online Classes

Contact Us: +919885348743