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.

Can I call a procedure inside a function?

0 Answers  

---

How many aggregate functions are available there in sql?

0 Answers  

---

what is online transaction processing (oltp)? : Sql dba

0 Answers  

---

what is difference between delete and truncate commands? : Sql dba

0 Answers  

---

Who developed sql?

0 Answers  

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

How do I remove duplicates in two columns?

0 Answers  

---

Explain the working of foreign key?

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

How do you retrieve the second highest salary from a table?

3 Answers  

---

what are the join types in tsql? : Transact sql

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---