Alternate to “like” Keyword of SQL
You may come across a situation, where you need alternate to the “like” keyword of SQL, that is to search for sub-strings in columns of the table. The one way to achieve it to use instr() function, instr() function takes 3 parameters in account. Syntax : instr( rank, string, sub_string ) Rank: Integer type expression… Read More »
