Like operator-comparison operators, PL-SQL Programming

LIKE Operator

You use the LIKE operator to compare the character value to a pattern. The Case is significant. LIKE returns the Boolean value TRUE when the character patterns match or FALSE when they do not match.

The patterns matched by the LIKE can involve two special-purpose characters known as the wildcards. An underscore (_) matches precisely one character; a percent sign (%) matches zero or more characters. For illustration, if the value of ename is ’JOHNSON’, then the following expression is true:

ename LIKE ’J%SON’

Posted Date: 10/3/2012 5:25:38 AM | Location : United States







Related Discussions:- Like operator-comparison operators, Assignment Help, Ask Question on Like operator-comparison operators, Get Answer, Expert's Help, Like operator-comparison operators Discussions

Write discussion on Like operator-comparison operators
Your posts are moderated
Related Questions
Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Perform the following queries on the Hospital1.DB using SQL Anywhere (START EARLY!). a. Which patients have purchased the drug "Tylenol"? List the names and addresses. Arrange the

Effects of NULL for UNIQUE Specification When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of sev

I would like to have a custom MS Access database designed and coded that would help me schedule my customer's orders and that would help me track my employees production output and

DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Blocks: The fundamental program unit in the PL/SQL is the block. The PL/SQL block is defined by the keywords BEGIN, DECLARE, EXCEPTION, and END. These keywords partition the b

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..