What are all the difference between Like and Contains ?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 4 Yes | 0 No |
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.
Is This Answer Correct ? | 2 Yes | 6 No |
Is pl sql still used?
What are the Diff B/W Cursor and REF Cursor
What is pivot table in sql?
Should I use mbr or gpt?
What are the ways on commenting in a pl/sql code?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
What is sql stand for?
What does desc stand for?
what is mean by forward declaration and where we'll use it.
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?
How many joins can you have in sql?
What is the difference between anonymous block and named blocks?