What operators performs pattern matching? - Pattern matching operator is LIKE and it has to used with two attributes 1. % and 2. _ ( underscore ) % means matches zero or more characters and under score means matching exactly one character

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL

DETAILS

Question: What operators performs pattern matching?

Answer: Pattern matching operator is LIKE and it has to used with two attributes 1. % and 2. _ ( underscore ) % means matches zero or more characters and under score means matching exactly one character

Category	SQL Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9114 users
Added on	7/25/2011
Views	74006
Rate it!

Question: What operators performs pattern matching?

Answer:

Pattern matching operator is LIKE and it has to used with two attributes 1. % and 2. _ ( underscore ) % means matches zero or more characters and under score means matching exactly one character Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?	View Answer
	What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features & advantages in Oracle and MS Access?	View Answer
	Can we call user defined packages in SQL statements?	View Answer
	What is normalization,types with eg's. _ with queries of all types?	View Answer
	Difference between a equijoin and a union	View Answer
	What is database?	View Answer
	How to store directory structure in a database?	View Answer
	Difference between VARCHAR and VARCHAR2?	View Answer
	Why do I get "Invalid Cursor State" errors when I insert/update/delete data with executeQuery()?	View Answer
	How to write a sql statement to find the first occurrence of a non zero value?	View Answer
	Given an unnormalized table with columns:	View Answer
	How write a SQL statement to query the result set and display row as columns and columns as row?	View Answer
	What is cluster.cluster index and non cluster index	View Answer
	If Delete Any Table In Back-End Then What Are The Triggers will Fire Automatically (Those Triggers Are Back-End Triggers Only)	View Answer
	How can i hide a particular table name of our schema.	View Answer
	What is the main difference between the IN and EXISTS clause in subqueries??	View Answer
	In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?????	View Answer
	What is difference between DBMS and RDBMS?	View Answer
	Given an employee and manager table, write a SQL syntax that could be used to find out an employee's manager's manager, assuming all managers are in the employee table.	View Answer
	What is the advantage to use trigger in your PL?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Interview Questions & Answers - Exam Mode / Learning Mode