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 is user defined functions? : Sql dba

0 Answers  

---

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

---

What are different types of functions in sql?

0 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---

What is natural join in sql?

0 Answers  

---

Why use stored procedures?

0 Answers  

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

difference between oracle 8i and oracle 9i

8 Answers  

---

how to find 5th row ?

10 Answers  

---

Can we use pl sql in mysql?

0 Answers  

---