State the use of ‘Like’ Operator.

State the use of ‘Like’ Operator.
by

1 Answer

Answer :

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are two operator often used in conjunction with the LIKE operator:

 %:The percent sign represents zero, one, or multiple characters

 _: The underscore represents a single character.
by

Related questions

State the use of sequence.

Description : State the use of sequence.

Last Answer : A sequence refers to a database object that is capable of generating unique and sequential integer values. Syntax: Create sequence [increment by num][start with num] [maxvaluenum] [ ... can be used for multiple tables. * Sequence numbers are stored and generated independently of tables

State the properties of Transaction

Description : State the properties of Transaction

Last Answer : The ACID properties of transaction. 1. Atomicity. 2. Consistency. 3. Isolation.  4. Durability

Describe the use of primary key and unique key constraints with example?

Description : Describe the use of primary key and unique key constraints with example?

Last Answer : There are two Entity constraints: 1.Primary Key constraint 2. Unique Constraint 1. Primary Key constraint: It is use to avoid redundant/duplicate value entry within the row of specified column in ... TABLE PERSONS (P_ID NUM CONSTRAINT P_UK UNIQUE , FIRSTNAME VARCHAR(20), CITY VARCHAR(20) );

Enlist different types of database users.

Description : Enlist different types of database users.

Last Answer : Database users are the one who really use and take the benefits of database. There will be different types of users depending on their need and way of accessing the database. 1. Application Programmers 2. Sophisticated Users 3. Specialized Users 4. Native Users/ Naïve Users

List the types of Cursor.

Description : List the types of Cursor.

Last Answer : Cursor: A cursor is a temporary work area created in the system memory when a SQL statement is executed. Types of Cursor: 1.Implicit Cursor 2.Explicit Cursor

Write syntax to create view.

Description : Write syntax to create view.

Last Answer : Create view as select OR CREATE VIEW name ASSELECT column1, column2.....FROM table_nameWHERE [condition];

State use of scope resolution operator.

Description : State use of scope resolution operator.

Last Answer : It is used to uncover a hidden variable. Scope resolution operator allows access to the global version of a variable. The scope resolution operator is used to refer variable of class anywhere in program ... to define function outside of class.  Return_typeclass_name:: function_name( )  {  }  

State and describe use of pointer operator and address operator. Give one example of each.

Description : State and describe use of pointer operator and address operator. Give one example of each. 

Last Answer : Pointer operator:- * It is used to declare a pointer variable. Also used as "value at" operator to read value stored inside the address pointed by pointer. Example: int *ptr; Address operator:-& ... address of a variable can be stored in pointer variable. Example: int a,*ptr; ptr=&a;

How do I get crane operator certification for NY State?

Description : How do I get crane operator certification for NY State?

Last Answer : You should ask the construction company exactly what certification is required. State and even city laws may require different types of certifications and the specific company could have more rigorous ... National Commission for the Certification of Crane Operators at http://www.nccco.org/ .

When an aircraft subjected to unlawful interference has landed in a Contracting State, it shall notify by the most expeditious means of the State of Registry and the State of the Operator of the landing and, in addition, shall similarly transmit all other relevant information to: a. Each State whose citizens suffered fatalities or injuries, each State whose citizens were detained as hostages, each State whose citizens were known to be on board and ICAO b. ICAO only c. Each State whose citizens were known to be on board only d. ICAO and each State whose citizens were known to be on board only

Description : When an aircraft subjected to unlawful interference has landed in a Contracting State, it shall notify by the most expeditious means of the State of Registry and the State of the Operator of the landing and, ... be on board only d. ICAO and each State whose citizens were known to be on board only

Last Answer : a. Each State whose citizens suffered fatalities or injuries, each State whose citizens were detained as hostages, each State whose citizens were known to be on board and ICAO

Who has the final authority as to the disposition of the aircraft? a. The State b. The Operator c. The Commander d. The Owner

Description : Who has the final authority as to the disposition of the aircraft? a. The State b. The Operator c. The Commander d. The Owner

Last Answer : c. The Commander

After an act of unlawful interference a report is to be made. When and to whom? a. Within 10 days and to the Authority of the State of Registry b. Immediately and to the Authority of the State of the airspace in which the event occurred c. Without delay, to the designated local authority and the Authority of the State of Registration d. Without delay, to the designated local authority and the Authority of the State of the Operator

Description : After an act of unlawful interference a report is to be made. When and to whom? a. Within 10 days and to the Authority of the State of Registry b. Immediately and to the Authority of ... d. Without delay, to the designated local authority and the Authority of the State of the Operator

Last Answer : d. Without delay, to the designated local authority and the Authority of the State of the Operator

When an aircraft subjected to unlawful interference has landed in a Contracting State, it shall notify by the most expeditious means of the State of Registry and the State of the Operator of the landing and, in addition, shall similarly transmit all other relevant information to: a. Each State whose citizens suffered fatalities or injuries, each State whose citizens were detained as hostages, each State whose citizens were known to be on board and ICAO b. ICAO only c. Each State whose citizens were known to be on board only d. ICAO and each State whose citizens were known to be on board only

Description : When an aircraft subjected to unlawful interference has landed in a Contracting State, it shall notify by the most expeditious means of the State of Registry and the State of the Operator of the landing and, ... on board only d. ICAO and each State whose citizens were known to be on board only

Last Answer : a. Each State whose citizens suffered fatalities or injuries, each State whose citizens were detained as hostages, each State whose citizens were known to be on board and ICAO

Who has the final authority as to the disposition of the aircraft? a. The State b. The Operator c. The Commander d. The Owner

Description : Who has the final authority as to the disposition of the aircraft? a. The State b. The Operator c. The Commander d. The Owner

Last Answer : c. The Commander

State True or False. i) While overloading operators new operator can be overloaded. ii) The binary operator such as +, -, * and must explicitly return a value. A) True, True B) True, False C) False, True D) False, False

Description : State True or False. i) While overloading operators new operator can be overloaded. ii) The binary operator such as +, -, * and must explicitly return a value. A) True, True B) True, False C) False, True D) False, False

Last Answer : C) False, True

State any four rules for operator overloading.

Description : State any four rules for operator overloading.

Last Answer : Rules for operator overloading: 1. Only existing operators can be overloaded. New operators cannot be created. 2. The overloaded operator must have at least one operand that is of user defined type. 3. ... * and / must explicitly return a value. They must not attempt to change their own arguments. 

Does Python have a ternary conditional operator like C -Web-Development

Description : Does Python have a ternary conditional operator like C -Web-Development

Last Answer : answer:

I am an owner operator of my own truck, are there any trucking jobs on the east coast for someone like me?

Description : I am an owner operator of my own truck, are there any trucking jobs on the east coast for someone like me?

Last Answer : Have a look at www.bigrigjobs.com. You should be able to find some trucking jobs on the east coast.

. Which of the following is a comparison operator in SQL? (A) = (B) LIKE (C) BETWEEN (D) All of the above

Description : . Which of the following is a comparison operator in SQL? (A) = (B) LIKE (C) BETWEEN (D) All of the above

Last Answer : D) All of the above