Alternate to “like” keyword of SQL
You may come across the situation, where you need alternate to “like” keyword of SQL, that is to search for sub-string 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… Read More »