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 the starting oracle error number?

0 Answers  

---

How many triggers can be applied to a table?

0 Answers  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

What is indexes?

0 Answers  

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

how many tupples can insert in 1 second in sql

1 Answers  

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

What is pl sql quora?

0 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---