Interested to Buy Any Domain ? << Click Here >> for more details...
What are all the difference between Like and Contains ?
- 2 Answers
- 10889 Views
- LG Soft, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What types of commands can be executed in sql*plus?
Can we use join in subquery?
What is break?
How is data stored on a disk?
What is Collation Sensitivity ? What are the various type ?
Why cross join is used?
Which join is default?
Why primary key is required?
What is pl sql record in oracle?
What is an exception in pl/sql?
What are the ways on commenting in a pl/sql code?
Can we rollback after truncate?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is sql deadlock?
Can you selectively load only those records that you need? : aql loader
