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 we write dml inside a function in sql server?

0 Answers  

---

Why triggers are used?

0 Answers  

---

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

How do you change a value in sql?

0 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

0 Answers  

---

What is normalisation and its types?

0 Answers  

---

Are stored procedures compiled?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

How to load data with sql*loader?

0 Answers  

---