Answer / rubyna

Like gives additional option of specifying exact
string/character position in the text. eg. if we want to
search all words having second letter 'a', we can use like,
but cannot use contain-

select * from emp where emp.name like '_a%'.

We don't have corresponding statement with contains.

Answer / santosh acharya

Select * from myTable where textField like '%Cats and Dogs%'

Select * from myTable where CONTAINS(textField, '"Cats and
Dogs"')

Both options will only return rows that contain the exact
phrase "Cats and Dogs", neither will return records that
contain either "Cats" or "Dogs" in them.

What does joining a thread mean?

0 Answers  

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

How to use boolean type in select statement?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

Is merge a dml statement?

0 Answers  

---

Explain what is a view?

0 Answers  

---

What is write ahead logging in sql server?

0 Answers  

---

how to insert the records in particular position

1 Answers  

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

0 Answers  

---

Why is sql important?

0 Answers  

---

How do you create a db file?

0 Answers  

---

Explain the structure of pl/sql in brief.

0 Answers  

---