INSTR examples in Oracle

Database
Oracle

INSTR examples in Oracle

Different uses of INSTR function in Oracle are shown here. Example-1: use of INSTR from the beginning of the string SELECT INSTR( ‘Eat to live, not live to eat’, ‘eat’ ) TEXT FROM dual; Output: Example-2: use of INSTR with positions and occurrence SELECT INSTR( ‘Eat to live, not live to eat’, ‘live’, 5, 2) […]

Read More